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 | ||
Recent Comments