Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
darkdusky
Aged Yak Warrior
591 Posts |
 Posted - 2008-12-22 : 07:32:54
|
| I have a report with matrix with: multiple columns for every working hour. 5 rows for working days.I would like to insert an average for each individual column. Eg. the average of Column A over the time 9am to 5pm, and same for Column B, and Column C.LayOut:..........9:00.........10:00........11:00........12:00......Averages.......A...B...C....A...B...C....A...B...C....A...B...C.....A...B...CMonTueWedThurFri |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-22 : 07:58:49
|
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-22 : 09:23:23
|
| The question is - How do you insert average columns at end of a matrix, as shown in example layout."I would like to insert an average for each individual column. Eg. the average of Column A over the time 9am to 5pm"The Row Grouping is by day and the column grouping is by hour. Can you elaborate on what I have left out of question? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-22 : 09:27:44
|
1. Sample data2. What do A, B and C represent?Maybe the whole thing is this simple?AA = (A1 + A2 + A3 + A4) / 4.0EBB = (B1 + B2 + B3 + B4) / 4.0ECC = (C1 + C2 + C3 + C4) / 4.0E
E 12°55'05.63"N 56°04'39.26" |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-22 : 10:16:00
|
| Got it sorted.I didn't need an average worked out. I just wanted to know How to add an average (or any other calculated column) into a matrix. - It's been a while since I worked on it. |
|
|
|
|
|
|
average columns