Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to make my sum of total sales (measure) be greater than or equal to $50k. I want to eliminate all lines that are under $50k from the sheet. Not sure whether a set analysis will work or if there is something I have to change in one of my dimensions.
Thanks in advance
Have you tried an expression like if(sum(sales)>=50000,sum(sales),Null()) ?
Hard to say exactly without some sample data.
John
(aka johncaqc)
Have you tried an expression like if(sum(sales)>=50000,sum(sales),Null()) ?
Hard to say exactly without some sample data.
John
(aka johncaqc)
Hey John,
Thank you for your response. This as well as a few other suggested expressions did not work. I believe I need to use dimension limitations in order for all columns to go away not just sales amount when the sales amount is under 50k. Any way you could help with this?
Thanks,
Josh
Can you share some sample data, and expected output?
John
(aka johncaqc)