I'm having a challenge with Pivot Tables. I'm not as well versed as I should be but am slowly learning their benefits.
I have source data that I would like to create a Pivot similar to this from a data set but am not sure how. If a single User were selected than only the records with a "Y" would be displayed.
User 01 User 02 User 03 User 04
Report 1 N N N Y
Report 3 Y N N N
Report 5 N Y Y N
Report 6 N Y N N
Report 7 N Y N N
Report 8 Y N N N
Report 10 N N Y N
I have attached a sample workbook.
Thanks for your assistance,