CODEWITHSUNDEEP
reporting-servicesssrs-2008
Amarundo
Amarundo

Reputation: 2397

How to Interactive Sort by Aggregate / Calculated Columns in SSRS 2008

I have a stored procedure that return a detailed table with 

agentid (varchar) , 
totalcalls (int) , 
talktime (int - seconds), 
holdtime (int - seconds)

For each hour.

So I have a SSRS tablix that sums totalcalls per agentid for a given period of time (parameters to the report)), sums talktime and holdtime too, and then I have two columns in the tablix that displays percentage of talktime (sum(talktime) / sum(talktime)/sum(holdtime)) and percentage of hold time (similar formula)

What I want to provide is for the user to sort by any of those percentage columns, so they can see who talks the most, the least, etc.

My question is, how do I Interactive Sort on those columns?

Thanks!

Upvotes: 3

Views: 7543

Answers (1)

hemanth
hemanth

Reputation: 587

Go to table column header textbox(talktime) properties, click on "interactive Sorting" add sort expression as your required percentage formula "(sum(talktime) / sum(talktime)/sum(holdtime))" then click ok.. even you can add sorting to header "holdtime" text box with respective formula.

enter image description here

Upvotes: 5

Related Questions