Split up an Excel pivot table based on field, similar to a page
Hey there, I'm trying to figure this out but I'm stuck. I'm attempting to generate an Excel pivot table that lists out a count of values per person on a month to month basis. My goal is to generate a sheet for each person, with each sheet containing the pivot table for the respective person and their counts.
If I try adding the person field as a page, I get the sheets for each person, but each pivot table contains all possible values. I've also tried adding the person field as a filter in the pivot table and using the "Show Report Filter Pages" option in Excel but that didn't seem to help much either. Not really sure what else to try at this point.
Re: Split up an Excel pivot table based on field, similar to a page
Sorry, forgot to mention the source table is coming from Qlik Sense, so no macros on that side . I'd like to avoid using Excel macros if possible, due to possible security concerns from the report recipients, but I'm open to ideas if there's no other option.