1

Is there a way in Excel to create a pivot table with multiple column totals?

Here's column names to demonstrate what I'm trying to do:

Jan | Feb | Mar | Apr | May | Jun | 6 Month total | Jul | Aug | Sep | Nov | Dec | 6 Month total | 12 Month total

The 12 Month total column is of course the regular Grand Total. The two 6 Month Total columns are the ones I'm looking to create.

Glen_b
  • 257,508
  • 32
  • 553
  • 939
ak112358
  • 111
  • 3

1 Answers1

3

Add a variable to indicate the total. In this case, 6 months is half a year, so we will call this variable "half". Sample data below for columns A,B,C

enter image description here

Now set up a pivot table with both half and month as rows and sales as the value, as shown below.

enter image description here

zbicyclist
  • 3,363
  • 1
  • 29
  • 34
  • 1
    Would be great if you copied excel output to the text file and then posted here as a code. Then it should look much nicer. – mpiktas Aug 05 '11 at 12:04
  • Can you explain a bit more how to setup the variables? I'm not seeing how to set it up. Specifically, how do I tell the one to only include the first 12 months and the other to only include the last 6? – ak112358 Aug 05 '11 at 17:49
  • @mpiktas: thanks for the suggestion. I hope this is clearer now. – zbicyclist Aug 13 '11 at 04:26
  • @zbicyclist That's cool! except the question asks for the Month to be in Column labels (trivial to figure out from your answer, I know....) – ak112358 Apr 28 '15 at 18:37