#1
|
||||
|
||||
Showing Count Instead of Sum in Pivot Table
Dear all,
My pivot table groups systems by versions. On the right of each version it summarizes the actual sum of the requested value of said systems, but I only need the count. Currently I collect this manually by adding an extra column, expanding the version in question, hover on the lower border of the version's cell, click, so excel selects all sub-elements, read 'count' from the status bar and write it into the corresponding column. Quite the busywork and error prone, so how to let excel do the job? Also tried Filed Value Settings -> Summarize value filed by ...but all options (which include 'count') are dimmed. Bummer. Any ideas? Thanks in advance, Visualization available here: Sign up to view this shared folder Carsten Last edited by Carsti; 09-29-2023 at 03:01 AM. Reason: Try to get the URL thru |
#2
|
||||
|
||||
Hi
please post a sample sheet. Pictures are useless to work with. Thx Also post your files on the board. External links are potentially unsafe
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
||||
|
||||
Thanks for the hint, didn't know how to put stuff on the board. And I'm not sure how to post a sample of my pivot table that works against a company' data-cube. Cannot really post internal information and you won't have access to the cube anyway. That's why I used a screenshot where I anonymized the confidential information...
Still anyone some ideas? |
#4
|
|||
|
|||
go advanced
to upload files. |
#5
|
|||
|
|||
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 |