Hello people,
So i am currently working to develop and Audit system for our company, and i am starting out with Excel, and having some trouble with the Pivot table.
The report i receive include some basic information (see attachement)
The Pivot i am looking to do, is something like this:
Employee ..| Total of "Y" | Total of "N" |
__________|______________|____________|
Employee 1 | (exemple 10) | (exemple 3) |
Employee 2 | (exemple 15) | (exemple 6) |
Employee 3 | (exemple 21) | (exemple 1) |
_________________ | TOTAL | |TOTAL |
I would like to be able filter with a Slicer the Employee, then be able to click on the total of N for exemple and get the complete row from the report out of it.
Could anyone look at the attachement report and help me out a little bit with it, would be much appreciated.
Bookmarks