I made a Tablix with Row and Column grouping that filters for the Top 10 highest. I also need Totals but it is totaling all of the records and of course I just want the total for the Top 10 ones in the table.
I tried using RunningValue but it doesn't reset with each Column Group.
How to get total of top 10 sales in SSRS 2012
Is there a way to only total the Top 10? I use the Dataset for other tables and charts so I'd rather not make separate ones (especially since I need the same functionality on other tables).