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