Paginated Report Builder row totals of filtered columns group

[ghousman7]

Hi all,

I have a matrix in Paginated Report Builder where the rows are grouped on job title and the columns are grouped on week #. Week # is filtered for Top n = 6. I need the Total to only sum the most recent 6 weeks, not all weeks. How would I limit the total column to just the most recent 6 weeks? 

Thank you for any help.

[GilbertQ · Accepted solution]

Hi @ghousman7 

You would need to use an Expression to create this.

Here is a close example of what you are looking for: summation of ssrs expression column (microsoft.com)