I have a table that contains
USER_NAME, USER_DEPARTMENT, REPORT_NAME and REPORT_RUN_DAY
Screen Shot 2014-04-10 at 1.52.24 PM.png
I created a pivot table as shown in the attached Picture, however for each record (row) it is counting as 1, I want to count unique number of employees for each department and unique number of reports each employee runs.
Any help would be appreciated.
Thanks
Moiz
Bookmarks