4 Replies Latest reply on Jul 12, 2017 12:06 PM by nataraj.vijayanagaram

    Select Column Based on Filter


      Hi All,


      I am trying to build a simple Dashboard using a calculated field and filters.


      I have attached the sample store workbook for reference. What I am trying to achieve:


      When no filters are selected - The bar chart should show value at the category level.

      When a specific category level is selected in the filter then the bar chart should show values at Sub-Category level as a drill down.. The list should show only the set of values that are relevant to the category selected.


      I tried to use CountD to calculate the filtered values and call a column in calculated filed but getting an error that cant use aggregate and non-aggregate values together.


      Can you some one please help me fix this issue.


      Thank you!