9 Replies Latest reply on Dec 16, 2014 9:35 AM by Eric Patterson

    How to hide values of an aggregated column from different datasource?

    Priyanka Patnaik


      Hi,

      I have two datasource (sales & Invoice) and the common field for both datasources are "region". I have taken invoice data as measure, aggregated at region level. but when i drill down the hierarchy to sub-region, i want  invoice to show only the sub-total and rest will be hidden.

      Desired output as as attached jpg format.

      I have also attached the workbook for you understanding.

      Please let me know how to achieve this. I tried a lot.. however cudn't succeed.

       

      Regards,

      Priyanka