Last, TopN, Sums – interesting aggregation issues in SSRS
I was trying to use a matrix report to return just the last quarter’s data for a specific dataset.
I didn’t want to show the whole year data, so Sum was out – Likewise I couldn’t use Last as the results went skewy as below
Using TopN for the Quarter Filter works to return the max quarter’s data for each year though
This was the formula
Just got to work out how to use the topN filter just for one data set (i.e. competitive base) but not for the other (Occupancy %) Hmmmmm
