3 Replies Latest reply: Jan 12, 2012 11:04 AM by Josh Duenyas RSS

    higher than 50,000

    Josh Duenyas

      Hi all

      I have a pivot table chart with 2 dimensions Industry and Customer and one expression of sum(transaction).

       

      I wish to show only those who had total transactions of 50,000 or more.

       

      The expression if(sum(Transactions)>50000,sum(transaction)) works but  the customers in the dimension who had less than 50000 remain in the list with ( - )  as total on their transactions. I wish to eliminate them from the list.

       

      Any idea how to tackle that?

       

      Thanks

      Josh