CODEWITHSUNDEEP
excelpivot-table
OVO
OVO

Reputation: 123

How to add the sum of values onto the column labels on excel?

I found an excel file that has the sum of all the values on the column labels on a Pivot Table. How is this done?

enter image description here

Upvotes: 0

Views: 8287

Answers (2)

Pichet Jiranarumit
Pichet Jiranarumit

Reputation: 186

enter image description here

You can move Σ Values between Column and Row Labels.

Upvotes: 0

Wyatt Shipman
Wyatt Shipman

Reputation: 1789

When you add more than one field to the values section, a Values field is place in the column labels to allow you to move the values above or below additional column labels. You can also move that values label to the row labels.

Upvotes: 1

Related Questions