2 of 2 people found this helpful
Make your own calcs.
Sum of Top-10 calc:
window_sum( IF [Rank Calc] <= 10 then sum(whatever-you-are-ranking) END )
Then you can use [Sum of top-10 calc] where you need to subtract it from something else.
See the Screenshot and attached.
- Calculate SUM(Sales)for Top 10.
- Keep it in the view
- Create a FIXED Calc for Overall Sales SUM
- Then Subtract your Top 10 Sales from FIXED LOD (Calculation1)
- To do this, just drag them from your view into the new Calculation2 and do substraction and That's It.
Hope it Helps!!!
Let me know.
Thanks Deepak. Cannot use lod as I am using excel SQL. Thanks
Then you can use TOTAL(SUM(SALES)) instead of LOD
I also have a month dimension. Month 1 month 2.. Dynamic month