Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
gibsontk1
Partner - Contributor II
Partner - Contributor II

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.

1 Solution

Accepted Solutions
Not applicable

There's no easy way to do this.

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

Best

Aran

View solution in original post

4 Replies
vvira1316
Specialist II
Specialist II

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
Partner - Contributor II
Partner - Contributor II
Author

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.

Not applicable

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
Partner - Contributor II
Partner - Contributor II
Author

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