The Subtotals in your solution is the Sum of Sales for all the products under each Category. Its not dynamic for the Top N .
Oh, sorry. Looks like so.
Let me think for a while.
1 of 1 people found this helpful
In TOP N's case, instead of sum, you need to use running_sum.
<<to Only show last row of each category>>
[Sub Total Display]
if [Calculation1]=[Top X]
if ([Calculation1])<=([Top X])
then RUNNING_sum(sum([Sales])) END
Thank you Shin, that helped.
any idea how to let users export the underlying data for the top X list only ??
Is there a way to create a button to do the export ??