SSRS Tablix - Total with Top N

707 views Asked by At

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).

enter image description here

0

There are 0 answers