Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Josh,
Set the same expression but using set analysis instead of a conditional:
Sum({< Transactions = {"=Sum(Transactions) > 50000"} >} Transactions)
Hope that helps.
Miguel
Hi Josh,
Set the same expression but using set analysis instead of a conditional:
Sum({< Transactions = {"=Sum(Transactions) > 50000"} >} Transactions)
Hope that helps.
Miguel
Well actually I lied.
In the expression I also have a lcolumn for Invoice number and a column for Department.
When removing those it works fine.
So plese disregard the question.
Thanks anyways.
Josh
Thanks Miguel
Actually I resolved the problem and figuered out what I did wrong. See my own reply to myself.
Your solution of course, using set analysis is the a better apporoach and more elegant.
Thanks