How do I add months in Pivot Table?
WhoisDannie
Posts: 63 Forumite
in Techie Stuff
I have made a pivot table of my electrical usage but I cannot get it to display the month's totals, I can only display the grand total.
How do I get the month's total to show?
How do I get the month's total to show?
28-Nov | 5.313 | ||
29-Nov | 5.258 | ||
30-Nov | 5.158 | ||
Dec | |||
01-Dec | 11.139 | ||
02-Dec | 5.464 | ||
03-Dec | 9.51 | ||
04-Dec | 5.395 | ||
05-Dec | 12.251 | ||
06-Dec | 4.951 | ||
07-Dec | 5.484 | ||
08-Dec | 11.958 | ||
09-Dec | 5.209 | ||
10-Dec | 8.476 | ||
11-Dec | 5.859 | ||
12-Dec | 5.666 | ||
13-Dec | 0.112 | ||
Grand Total | 2590.364 | ||
0
Comments
-
Have you tried deselecting days.That is just a first suggestion, perhaps you could post which program/app/version you are using, as it could be one of several....0
-
Heedtheadvice said:Have you tried deselecting days.That is just a first suggestion, perhaps you could post which program/app/version you are using, as it could be one of several....
I want the months total to appear after 30th Nov usage where there is a blank space after Dec.
Excel 20130 -
Add days back into the grouping option.Click anywhere in the pivottable, click in the Design tab in the Pivottable Tools section of the tab bar. You should see a Subtotals button appear in the menu bar. Choose one of the 'show all subtotals' options.1
-
There you have one neat method. As is typical within Excel several ways to get the subtotals from the data.
0 -
outtatune said:Add days back into the grouping option.Click anywhere in the pivottable, click in the Design tab in the Pivottable Tools section of the tab bar. You should see a Subtotals button appear in the menu bar. Choose one of the 'show all subtotals' options.
That was so simple.
0 -
WhoisDannie said:outtatune said:Add days back into the grouping option.Click anywhere in the pivottable, click in the Design tab in the Pivottable Tools section of the tab bar. You should see a Subtotals button appear in the menu bar. Choose one of the 'show all subtotals' options.
That was so simple.
1
Categories
- All Categories
- 343K Banking & Borrowing
- 250.1K Reduce Debt & Boost Income
- 449.6K Spending & Discounts
- 235.1K Work, Benefits & Business
- 607.8K Mortgages, Homes & Bills
- 173K Life & Family
- 247.8K Travel & Transport
- 1.5M Hobbies & Leisure
- 15.9K Discuss & Feedback
- 15.1K Coronavirus Support Boards