sorting on a calculated field ssrs

How do i sort on a calculated field? Trying to sort the locations by the 2010 YTD calculated field...
emp.png
LVL 1
k1ng87Asked:
Who is Participating?
 
itcoupleConnect With a Mentor Commented:
Try exactly the same expression with interactive sorting

Should work (in theory)

Regards
Emil
0
 
itcoupleCommented:
Hi

You might be able to use expression. How was your YTD calculated? It might work with interactive sorting as well.

Regards
Emil
0
 
k1ng87Author Commented:
YTD is calculated like this...

=sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.