2 Replies Latest reply on Aug 1, 2016 5:49 AM by ravi.chaliki

    Subtotal of Categories in Rows (not columns)

    ravi.chaliki

      Hi Gurus,

       

      I would like to take some help on the following requirement - summary report:

      Raw data:

      Domain1 - Opex -

      Domain1 - Revex -

      Domain1 - Capex -

      Domain1 - FCC -

      Domain1 - Inv -

      Domain2 - Opex -

      Domain2 - Revex -

      Domain2 - Capex -

      Domain2 - FCC -

      Domain2 - Inv -

       

      I have a chart displaying totals for the following categories. Of which FCC = Opex + Revex and Inv = Capex + Revex. I HAVE to display the FCC and Inv in the same view as below.

       

      However, I have problem when I add the above Sheet 2 - "split-by-domain chart". When a category is selected related data is being displayed properly. But when I remove the filters Sheet 2 displays the Total of All categories instead of Opex+Revex+Capex.

       

      How can I achieve this? I am open to modify the raw data if required as it is being created within an Access module.

       

      I added the sample file for reference.

       

      Thank you in advance.

       

      Cheers,

      Ravi.

        • 1. Re: Subtotal of Categories in Rows (not columns)
          Luciano Vasconcelos

          Just to clarify:

           

          You don't want to use FCC and INV for Domain Totals?

           

          I didn't understand what is your exit report.

           

          If you want only Opex+Revex+Capex it's just remove action filter.

           

           

           

           

          And check in this filter what you want in total.

          • 2. Re: Subtotal of Categories in Rows (not columns)
            ravi.chaliki

            Hi Luciano,

             

            I need it working in the following scenarios:

            • I need the filter so that By Default the total includes O+C+R (excluding FCC and Inv).
            • If I select O/C/R, respective totals for domains should be displayed.
            • If I select FCC/Inv, respective totals for domains should be displayed.
            • If selection is removed from Sheet 1, total should include only O+C+R (excluding FCC and Inv)

             

            I am able to achieve the first 3 in my sample attached. However, once the selection is removed, the totals are including O+C+R+FCC+INV

             

            Can you suggest anyway to fix this?

             

            Thanks,

             

            Cheers,

            Ravi.