ReportViewer, Sum total but display name
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