Hi Deepak, thanks for the quick response. That's nearly what I'm looking for but the only value I'm trying to see on the KPI tile is the total sales of the Top N keyed in the parameter.
The workbook you included has each of the Top Customers listed and the Grand Total for them but I'm hoping to only see the Grand Total on the KPI tile. I looked through the link you provided as well regarding help with subtotals but I wasn't able to get the calculation to work correctly even with the Sample SuperStore Category info.
Any idea what I might be doing wrong?
I modified my Original Work in that Thread and Here is What I think you need:
and so on. Please See attached.
If it Helps, Please Mark it Helpful and CORRECT to Close Thread
Sum of TOP N as KPI.twbx 10.3 KB
Thanks so much for all of your help and time on this, Deepak! I really appreciate it.
We can achieve this by using below calculation:
IF [DR:Rank ]<=[Top N]
Can you please explain the purpose of :
IF FIRST()=0 THEN
WINDOW_SUM( IF [DR:Filter] THEN SUM([Amount])END,0,IIF(FIRST()=0,LAST(),0))