I have following 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:

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:

What I want:

CodePudding user response：

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.