Hello,
Below are 2 spreadsheets (Actual & Budget), I created a Pivot Table (PT) in another sheet using multiple consolidation ranges. How do I add the category to the PT? And is there an easier way to put Actual And Budget in the title rather than Item1 & 2?
Thanks,
XLML
Below are 2 spreadsheets (Actual & Budget), I created a Pivot Table (PT) in another sheet using multiple consolidation ranges. How do I add the category to the PT? And is there an easier way to put Actual And Budget in the title rather than Item1 & 2?
Thanks,
XLML
Book3 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Account# | Category | Actual | |||
2 | 1000-BANK | Cash | 5000 | |||
3 | 1050-BANK | Cash | 6000 | |||
4 | 2995-APAY | AccountsPayable | 25000 | |||
Actual |
Book3 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Account# | Category | Budget | |||
2 | 1000-BANK | Cash | 7500 | |||
3 | 1050-BANK | Cash | 4000 | |||
4 | 2995-APAY | AccountsPayable | 23000 | |||
Budget |
Book3 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
3 | SumofValue | Page1 | ||||
4 | Row | Actual | Budget | GrandTotal | ||
5 | 1000-BANK | 5,000.00 | 7,500.00 | 12,500.00 | ||
6 | 1050-BANK | 6,000.00 | 4,000.00 | 10,000.00 | ||
7 | 2995-APAY | 25,000.00 | 23,000.00 | 48,000.00 | ||
8 | GrandTotal | 36,000.00 | 34,500.00 | 70,500.00 | ||
PT |