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

    Select Column Based on Filter

    nataraj.vijayanagaram

      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!