title: How to get total of top 10 sales in SSRS 2012
body: <p>I am taking Top 10 of Sales Volume grouped by Product categories in SSRS 2012.
  I need the total of these top 10 but it shows the complete total. I cant do it on dataset level as I need the complete dataset for other parts in the report. I tried the solution as given in <a href="http://social.msdn.microsoft.com/Forums/sqlserver/en-US/0b21bab0-ff02-4655-a69c-efedfb2a7077/top-n-report-total-row-not-correct">MSDNlink</a> but that didn't help either. Thanks in advance.</p>