4 Replies Latest reply: Feb 15, 2016 11:46 AM by Cesar Accardi RSS

    Filter on Expression in table

    Diwakar Nahata

      Hi,

       

      I have created a Metric from Sales metric as below:

      =IF(sum(Sales)>10000,'Category-A', 'Category-B')

       

      I have used the above metric in a Table, where i want to have the ability to select or filter our the Categories as per the above expression.

       

      However, since the above categories are calculated as expression, i can neither select nor filter the same.

       

      How, can i limit the straight table to show only a specific Category?

       

      Regards,

      Diwakar