Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a data set similar to attached. I have created a master measure for sum(Sales Amount). In a table, I want to be able to enter greater than, less than or equal to value in the sum(Sales Amount) and filter the data.
What will be the best way to do this?
Any insights on this would be appreciated. Thank you!
Regards,
Sujeet Shirude
Hi Sujeet,
You can convert an expression into a dimension with the help of Aggr() function.
Aggr(sum(Sales Amount),yourDimensionsToCalculateExpression)
By this way you can provide filtering option for users.
Hi Sujeet,
You can convert an expression into a dimension with the help of Aggr() function.
Aggr(sum(Sales Amount),yourDimensionsToCalculateExpression)
By this way you can provide filtering option for users.
Thanks a lot, Serhan!
It worked.