Help!! How to add grand total for this pivot table?

Question

question

sumeeng asked Apr 11, '22 emilyhua-msft commented Apr 15, '22

Help!! How to add grand total for this pivot table?

office-excel-itpro office-scripts-excel-dev

excel-latest-q.jpg (912.6 KiB)

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JanardhanaVedham-MSFT · Apr 11 at 05:43 PM

Hi @SooMeeEng-6558 ,

Removed microsoft graph tags as it not related to Graph API.

0 ·

Answer 1 · 2022-04-12T03:09:28.257Z

emilyhua-msft answered Apr 12, '22 sumeeng commented Apr 15, '22

Hi @sumeeng ,

Could you please let us know how did you get the Values column?
Such as using a measure that you created in Power Pivot to calculate the sum of each item. Or this column just show the text with "Sum of XXXXXXX <Number>".

It's better to share us with a simple sample. Thanks for your understanding.

For general pivot table, to get the grand total, you can select the pivot table, go to Design tab > Layout group > Grand Totals, choose "On for Rows and Columns".

Any updates, welcome to post back.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

capture91.jpg (26.3 KiB)

· 5

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

sumeeng · Apr 12 at 03:32 AM

This is the pivot table fields which shows how I get the Values column (I just move the Values from column label to row label)
and I tried this (For general pivot table, to get the grand total, you can select the pivot table, go to Design tab > Layout group > Grand Totals, choose "On for Rows and Columns".) also, but the grand total did not appear.

0 ·

whatsapp-image-2022-04-12-at-112636-am.jpeg (47.5 KiB)

emilyhua-msft sumeeng · Apr 12 at 09:38 AM

Hi @sumeeng ,
Thanks for your sharing.

Based on my tests, the "Grand Totals, choose "On for Rows and Columns" does not work this pivot tabel as thw "Values" field is not recognized as a row field, still recognized as a column field.

I would suggest you try to insert a Caculated Field, that you can select this pivot table > PivotTable Analyze > Fields, Items, & Sets > Create a new field, and insert the related field in the list to get total sum.

Than you would find the results like following image.

If the fields is too much to inserted manually, it's recommended to use SUM formula.

0 ·

capture93.jpg (73.9 KiB)

capture94.jpg (9.7 KiB)

capture95.jpg (53.0 KiB)

sumeeng emilyhua-msft · Apr 13 at 01:23 AM

Good Morning, Emily. Thank you for the guidance. I got the sum of grand total. May I know is it possible to convert the number into percentage? Like 1711 show as 52.7% instead of 1711.

0 ·

Show more comments

question