I have a tablix that is totaling value for days (total of day 1, 2, 3, etc). I am trying to get anther column that will show the avg, min, max, for each device(row group) of the total of the days(column group), but it just keeps giving me the max (etc) for the device group per entry.
Example (raw data)
DeviceDateTimeValue
11/1/2013 2:002
11/1/2013 2:053
11/1/2013 2:305
21/1/2013 2:006
21/1/2013 2:058
21/1/2013 2:3010
11/2/2013 0:002
11/2/2013 2:054
11/2/2013 2:305
21/2/2013 2:006
21/2/2013 2:059
21/2/2013 2:3010
Table
Device 1/1/20131/2/2013Max (displayed)Max (wanted)
110.00 11.00 5 11
224.00 25.00 10 25