This content has been marked as final. Show 3 replies
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?