How do I add months in Pivot Table? 17 December 2022 at 1:05PM in Techie Stuff 6 replies 172 views

WhoisDannie

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?

	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

Heedtheadvice

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....

WhoisDannie

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....

yes. I get month totals if I just have months selected.

I want the months total to appear after 30th Nov usage where there is a blank space after Dec.

Excel 2013

outtatune

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.

Heedtheadvice

There you have one neat method. As is typical within Excel several ways to get the subtotals from the data.

WhoisDannie

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.

Thanks!
That was so simple.

outtatune

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.

Thanks!
That was so simple.

You're welcome!