|
#1
|
|||
|
|||
Hi, I think you just need to change the field value you're going for in the Values quadrant. Where it shows Sum of (value) (circled in the left side of the pic) you should be able to right click on that and find the Value Field Settings. Simply change from Sum to Count or any of the other options given.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why does the total row of my pivot table not tie to the real count using distinct count | wheddingsjr | Excel | 4 | 09-01-2020 09:52 PM |
Showing percentages in a pivot table | bremen22 | Excel | 1 | 06-22-2016 01:37 PM |
Data not showing in Pivot Table | MichelPierre | Excel | 2 | 01-26-2016 10:51 AM |
Create PIVOT chart using few rows in pivot table | Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
Field not showing in Pivot Table Field List | kmcovington | Excel | 0 | 10-26-2012 10:14 AM |