Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm showing a simple SUM(Measure) by a dimension A.
Now i would also like to show the SUM(Measure) for only for the TopX SUM(anotherMeasure) by dimension B ignoring dimension A
any suggestion
if A is the dmension of your chart, and your X is 3, is :
sum( if ( anothermesure >= max( total anothermesure , 3) , mesure ))
OK ?
(i'm not sure what is your dimension B in this context)
variable vTopX: 5
dimension: DimA
expression: sum({<DimB={"=rank(sum({<DimA=>}MeasureB))<=$(vTopX)"}>}MeasureA)
I was trying to do sth like that but was unable to find how to.
Very nice formula !