Hi guys,
I have a pivot table, where I use a rank function as an expression and want to show only 10 tops among all selection and I want to hide the null rows.
I have used the expression as such:
if(rank (sum (UnitCost*UnitsBalance),4)<=10, rank (sum (UnitCost*UnitsBalance)), Null())
I have turned the suppress when value is null and suppressed Zero-Values for all Columns in Presentation TAb.
I know how it is possible to use with AGGR function and did it already. However, is there a solution that I can simply edit my expression above?
