Hi
I have a pivot table set up and I want the column subtotals to count how many cells have numbers in them. Currently, the subtotals are just summing the values even if I change subtotals to 'count' in the field settings.
I have not attached the data as it is sensitive but any help would be appreciated. I can reconstruct the data if needed.
Thanks
Philip
Bookmarks