Check each relevant Pivot Table (you might have other Pivot Tables in your workbook that don't need this slicer).
It should bring up all the possible Pivot Tables in your sheet.
Right click each slicer and look for something like Connections.
Setup slicers for Name, Date, Site, and Supervisor.
Click Analyze in the ribbon (menu) up top.
To filter the Pivot Table like you're looking for, try using slicers. This could slow things down on your system depending on resources, and/or be annoying to keep up with as new data points (in your case, Categories) are added. The caveat here is that each Pivot Table is it's own, not one Pivot Table of everything. This will result in the data structure that you are looking for: Hide the first row of the first Pivot table, and the first two rows of each of the next Pivot Tables. Repeat the process in the next available blank cell for the next category, which will produce something like this: The third row will be the count of each value in the above column. The second row will read all the possible values of the column. The first row will read Column Labels with a filter dropdown. This will produce a Pivot Table with 3 rows. Then I made multiple Pivot Tables, filling the Columns and Values Pivot Table Fields with one Category of each of your categories. To start, I replicated your dataset and set it up as a table: This solution will work, but comes with a caveat that can be worked around if you're willing to use slicers. It's rather annoying in Excel (plug for Pandas/Python). The benefit of this approach is that it is one pivot and can be easily refreshed when/if data is updated. Any variable can be used as a count in the values section as long as it is present for all records.
Create a pivot table and add Attribute as a row and Value as columns.
Close and load this data to the excel sheet (or the data model).
This will melt your data into a tidy format.
Click on the arrow next to unpivot columns and select 'Unpivot Other Columns'.
Select all columns from Person Name to Supervisor ctrl and click on each column or click Person Name and, while holding shift, click Supervisor).
In Power Query go to the Transform ribbon.
On the Data ribbon click 'From Table/Range'.
Enable PowerPivot if required (if using 2016 it is enabled by default otherwise see this link).
Person Name | Date | Case | Site | Supervisor | Category | Value You don't mention which version of Excel you are using but assuming you have Excel 2013+ I would load the data into Power Query where you can unpivot the data so that each row is