Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As you can see from the picture, the line for "Large Corp" disappeared because of the usage of Above function.
I want to specific the calculation using above function refer to dimension "Quarter" and then split by Dimension "Size".
Is there any solution for this?
This is the formula of measure : (sum(Outstanding)-Above(Sum(Outstanding)))/Above(Sum(Outstanding))
Try this:
Aggr((Sum(Outstanding) - Above(Sum(Outstanding)))/Above(Sum(Outstanding)), Size, Quarter)
Try this:
Aggr((Sum(Outstanding) - Above(Sum(Outstanding)))/Above(Sum(Outstanding)), Size, Quarter)
Or this:
Aggr((Sum(Outstanding) - Above(Sum(Outstanding)))/Above(Sum(Outstanding)), Size, (Quarter, (TEXT, ASCENDING)))
Thanks a lot. I gt it right.