I am exporting several sets of data from sql via a web app to Excel. Is it possible to format this data. In particular I would like to use the "Subtotal" function in Excel using "sum" at each change in Shift Set. Below is an example of what the spreadsheet looks like. In this case I would like columns "Employees" through "Sat" to be summed twice: once for shit set 6 and once for shift set 7.
| ScheduleHeaderID |
Date |
TotalEmployees |
TotalShifts |
DisplayName |
Minimum |
Maximum |
NeededMon |
NeededTues |
NeededWed |
| 288 |
6/4/2010 9:14 |
57 |
251 |
6/4/2010 - 57 emps |
51 |
62 |
40 |
45 |
38 |
| |
|
|
|
|
|
|
|
|
|
| Shift Set |
Shift ID |
Employees |
SUN |
MON |
TUE |
WED |
THU |
FRI |
SAT |
| 6 |
155 |
14 |
14 |
14 |
14 |
0 |
0 |
14 |
0 |
| 6 |
136 |
17 |
0 |
0 |
17 |
17 |
17 |
17 |
0 |
| 6 |
162 |
5 |
5 |
5 |
5 |
0 |
5 |
5 |
0 |
| 6 |
152 |
9 |
9 |
9 |
0 |
9 |
9 |
9 |
0 |
| 6 |
171 |
12 |
12 |
12 |
12 |
12 |
12 |
0 |
0 |
| 7 |
155 |
14 |
14 |
14 |
14 |
0 |
0 |
14 |
0 |
| 7 |
136 |
17 |
0 |
0 |
17 |
17 |
17 |
17 |
0 |
| 7 |
162 |
5 |
5 |
5 |
5 |
0 |
5 |
5 |
0 |
| 7 |
152 |
9 |
9 |
9 |
0 |
9 |
9 |
9 |
0 |
| 7 |
171 |
12 |
12 |
12 |
12 |
12 |
12 |
0 |
0 |