Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
praveenpurush6
Contributor III
Contributor III

Add a Total Value to the Pivot Table

Hi All,

I have a created a pivot table from a excel list.

How to add a value called 'Total" to the "Base" column which is the total of all G-Codes of a Base.

In the sample for base value "A" the Total is 11.

or

How to calculate the sum of the individual G-Codes?

Q.JPG

Thanks!

Praveen.

1 Solution

Accepted Solutions
marcus_sommer

Go to the tab presentation and on the top left area you could enable the totals for each single dimension.

ps: Please do not double/triple posting.

- Marcus

View solution in original post

4 Replies
marcus_sommer

Go to the tab presentation and on the top left area you could enable the totals for each single dimension.

ps: Please do not double/triple posting.

- Marcus

asmitagg
Partner - Contributor III
Partner - Contributor III

In the presentation tab tick the "show partial sums" option for each dimension and expression.

regards,

Asmita

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Marcus, Sunny and me are getting the impression that the multiple posts of the exact same question is not intentional. Most of these double posts have sequential IDs and are at most minutes apart. Also, almost all of them are posted in one and the same forum (we've assembled a list of more than 30 similar cases)...

Praveen, were you experiencing delays when you first pressed the "Post" button? Did you click it multiple times because there was no reaction from the Community site?

praveenpurush6
Contributor III
Contributor III
Author

Hi Peter,

There was a delay when I tried to post the question.