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

    Filter on Expression in table

    Diwakar Nahata



      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?