:confused:
Hi all,
I am trying to make a pivot table on a data part of which look like this
Unit Project Check-1 Check-2 Check-3
U-1 Proj-1 Yes No Yes
U-2 Proj-1 No No Yes
U-1 Proj-1 No Yes No
U-2 Proj-1 No Yes YEs
There are lot of Checks in my data and the possible anwer to it is Yes/No
Now what I want to do is i want to create a pivot table which will give me Unitwise, Projectwise count of Yes/No under respective check.
Just to make easy to understand it should give me result something like