How to count number of times a specific value occurs in Pivot Table?

anzzz 0
Viewed 21

I have following table: Excel Table

I want to create pivot table that would count for each of groups the number of Review & Re-review. Something that would look like this:

Desired excel table

I need to do it as pivot table because I want to be able to catch proper data after a double click.

WHAT I TRIED:

I tried to split "Kind of task" column in to two: Review & Re-review. That gives me proper pivot table output, but when I want double click on a cell to provide me input data I have data for overall "Kind of task" not for specific "Kind of task".

Example, what I've got after clicking cell under Re-review in Category A row:

enter image description here

What I want:

enter image description here

excel
1 Answers

I'm not able to duplicate your issue. If you put Category in rows, Kind of task in columns, and count the number of Names, you get an output similar to yours (total is wrong direction). From there, double-clicking on reriew for category a does return the screenshot you indicated you wanted.

Check your pivot settings against this Sample spreadsheet.

pgSystemTester0
Related