| Table 1: Sample Output from PivotTable.vbs | ||||||
| Sum of Amount | Quarter | |||||
| Name | Description | 1 | 2 | 3 | 4 | Grand Total |
| Jack | Electricity | 8 | 26 | 65 | 13 | 112 |
| Telephone | 17 | 41 | 71 | 31 | 160 | |
| Water | 38 | 82 | 87 | 52 | 259 | |
| Jack Total | 63 | 149 | 223 | 96 | 531 | |
| Joe | Electricity | 16 | 36 | 1 | 13 | 66 |
| Telephone | 18 | 4 | 0 | 0 | 22 | |
| Water | 47 | 13 | 34 | 19 | 113 | |
| Joe Total | 81 | 53 | 35 | 32 | 201 | |
| Judy | Electricity | 17 | 1 | 8 | 0 | 26 |
| Telephone | 16 | 20 | 30 | 8 | 74 | |
| Water | 33 | 28 | 50 | 35 | 146 | |
| Judy Total | 66 | 49 | 88 | 43 | 246 | |
| Grand Total | 210 | 251 | 346 | 171 | 978 | |