0
Reply

ReportViewer, Sum total but display name

Poppa Wallace

Poppa Wallace

Feb 19 2012 10:22 AM
3.6k
Hi all I am trying to gather a sum from a column to determin which item has had the most sent on it

So


jay  10
kai  25
mark 55
jay  20
jay 55
kai 1


And the value from Jay together gives me 85, but I want to display the name jay rather than the sum. Any ideas

?

the table which I want the name from
 =Fields!Module.Value
and the sum table
=Sum(Fields!Cost.Value)

thanks in advance