I have a detailed recordset of helpdesk calls for a report that summarises into differing views by category, status etc.
One of the demands on the report is to show top 5 applications by total calls logged over 5 weeks.
The tablix has week number as the columns, applications as the rows and count(callid) as the data. I have added a total column that counts all callid
I cannot find where to apply the limit of top 5 applications by total callid. An aggregate cannot be used in the tablix filters i'm told when trying it.
One of the demands on the report is to show top 5 applications by total calls logged over 5 weeks.
The tablix has week number as the columns, applications as the rows and count(callid) as the data. I have added a total column that counts all callid
I cannot find where to apply the limit of top 5 applications by total callid. An aggregate cannot be used in the tablix filters i'm told when trying it.