Grand total excel pivot table help

Hello everyone,

I need help for the Grand total.
I need a sub grand total for the month. See example below:

Total sale of Cookies (June and July) 9
Jun 4
Jul 5
Total sale of Bread (June and July) 8
Jun 3
Jul 5
Grand Total 17

I need a grand total for June and July. See below:
Total sale of Cookies (June and July) 9
Jun 4
Jul 5
Total sale of Bread (June and July) 8
Jun 3
Jul 5
Grand Total 17
Jun 7 <- Need this to show on my pivot table below Grand Total
Jul 10<- Need this to show on my pivot table below Grand Total

Thank in advance. I desperately need help.

Originally Posted by Ace_XL

Wouldn't dragging pivot fields related to the month (June, July etc.) onto the column fields give you the monthly breakdown too? (albeit in different columns and not one below the other)

Hi Thank you for your reply,

I wouldn't be able to drag the fields since I actually have several columns on the Pivot table. I only showed on column as an example.
But if you can give me more specific instructions, maybe I can check it if would work?
Thanks for your time.

Originally Posted by Ace_XL

Could you upload a sample worksheet, would be easier to work of!

Hi, I uploaded a sample for you to see.

Thanks in advance.

Bump...
I really need the help.
Thanks.

Hello,

Drag the "Month" Field into the Column Field instead Row or check if this still does not do the trick, check the field options to make sure you have it set to work out the total (Automatic also does it on mine).

Thank you Ace-XL and Jamesr571! I really appreciate both of your help. Both advices are similar and helps me.