Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Average, Min, Max from row group in tablix Expand / Collapse
Author
Message
Posted Thursday, March 7, 2013 7:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 8, 2013 1:56 PM
Points: 1, Visits: 5
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)
Device DateTime Value
1 1/1/2013 2:00 2
1 1/1/2013 2:05 3
1 1/1/2013 2:30 5
2 1/1/2013 2:00 6
2 1/1/2013 2:05 8
2 1/1/2013 2:30 10
1 1/2/2013 0:00 2
1 1/2/2013 2:05 4
1 1/2/2013 2:30 5
2 1/2/2013 2:00 6
2 1/2/2013 2:05 9
2 1/2/2013 2:30 10

Table

Device 1/1/2013 1/2/2013 Max (displayed) Max (wanted)
1 10.00 11.00 5 11
2 24.00 25.00 10 25
Post #1427995
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse