Split up an Excel pivot table based on field, similar to a page

[gibsontk1]

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.

[vvira1316]

Would you consider using a macro? If your can use macro then it may be possible.

Following link may provide some insight and help

Macro to Export Multiple Object into Multiple sheet loop by Field and store it into paritcular Locat...

[gibsontk1]

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.

[#4 · Accepted solution]

There's no easy way to do this.

Will almost certainly require macros on a second workbook which references the NPrinting report.

Best

Aran

[gibsontk1]

Thanks! Sounds like more trouble than it's worth, so I'll look into alternatives.