Hi, can someone help to see whats wrong with my pivot? I have click n Total for Row. But its not showing.
Hi, can someone help to see whats wrong with my pivot? I have click n Total for Row. But its not showing.
Your row values are discrete Data Fields... to a get a total of the 4 data fields either
a) create a Calculated Field in your Pivot, or (simpler)
b) add a Total column to your underlying Table, refresh the Pivot, add the new Field as a further Data Field
I would suggest having a look at the following:
https://www.contextures.com/excel-pi...ted-field.html
If you use Pivot Tables a lot, or are learning them, Debra Dalgleish's website will prove to be a great reference point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks