0
I am not even sure how to title this question. If you can give me a better title I will update the question.
Here is what I am trying to do:
Column Title: Status
A
(blank)
B
C
C
(blank)
B
I want the pivot table to use the row labels as A,B,C,(blank) but I also want the count of each. Can this be done without another column in a pivot table?
For example:
"Status" | count
A | 1
B | 2
C | 2
(blank) | 2
If not how can I aggregate the data?
Ultimately the goal is to pie chart the data.
I didn't realize in the new 2016 layout for pivot tables that you can do that. Simple enough. Thanks! – Shawn – 2016-07-21T17:52:21.937