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

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

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?

go advanced

to upload files.

Attached Images

	IMG_20231005_213327.jpg (76.0 KB, 11 views)
	IMG_20231005_213356.jpg (95.2 KB, 11 views)

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.

Attached Images

pivot-table.jpg (74.4 KB, 6 views)