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

Question

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

sumeeng 21

JanardhanaVedham-MSFT 3,566 Reputation points

2022-04-11T17:43:42.017+00:00

Hi @SooMeeEng-6558 ,

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

Accepted answer

0 additional answers

Your answer

JanardhanaVedham-MSFT 3,566 Reputation points

2022-04-11T17:43:42.017+00:00

Hi @SooMeeEng-6558 ,

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

Answer 1

Emily Hua-MSFT 27,796

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.

sumeeng 21 Reputation points

2022-04-12T03:32:25.75+00:00

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.
Emily Hua-MSFT 27,796 Reputation points

2022-04-12T09:38:06.79+00:00

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.
sumeeng 21 Reputation points

2022-04-13T01:23:16.57+00:00

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.
Emily Hua-MSFT 27,796 Reputation points

2022-04-13T03:36:27.03+00:00

Hi @sumeeng
Could you please let us know how do you get the percentage?
Such as which total number does 1711 account for to get the percentage 52.7%?

If it is the grand total that we get, then you can still insert new caculated field. Such as the "Percentage1" on image is the percentage for "Sum of 1".

Besides, you can also set the number foramt for "Percentage1".

If you need the formula, then you can try to use GETPIVOTDATA function to extract the specific data from Pivot Table, then get the percentage.
Emily Hua-MSFT 27,796 Reputation points

2022-04-15T01:19:25.223+00:00

Hi @sumeeng
I am checking thread, if my reply is helpful to you, could you please accept it as an answer?
This action can help other users on Q&A forum who encounter the same issue.
Any questions or updates, welcome post back. Thanks for your understanding.

Share via

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

0 additional answers

Your answer