Hi,
I've been looking all over for a solution, but to no avail.
I would like to get counts of Yes or No from a table with a.o. questions. In my example there are 4 questions, however the actual data has columns and will eventually be filtered based on employee, rank, location, territory etc, so unfortunately I couldn't just refer to the table with a formula's, but that could very well be my ignorance ;-).
In the following picture the blue stuff are my table and pivot results, yellow is what I would like to see.
PivotExample.png
Any help would be appreciated....
Mike
Bookmarks