Question asked on Jan 29, 2016
How can the below summary section (bottom of page) by customer be created with the above pivot table. Need to include it in the main pivot table. I know a second pivot table can be added as well as Excel formulas, but need to keep this with the above data.
| Report by Brand by Customer | ||
| Brand A | ||
| Customer A | 100 | |
| Customer B | 200 | |
| Customer C | 300 | |
| Customer D | 400 | |
| Total Brand A | 1,000 | |
| Brand B | ||
| Customer A | 500 | |
| Customer B | 600 | |
| Customer C | 700 | |
| Customer D | 800 | |
| Total Brand B | 2,600 | |
| Brand C | ||
| Customer A | 1,000 | |
| Customer B | 1,100 | |
| Customer C | 1,200 | |
| Customer D | 1,300 | |
| Total Brand C | 4,600 | |
| Grand Total | 8,200 | |
| Total Customer A | 1,600 | |
| Total Customer B | 1,900 | |
| Total Customer C | 2,200 | |
| Total Customer D | 2,500 | |
| 8,200 | ||
Write an answer