4 Replies Latest reply: Oct 6, 2017 2:40 PM by Travis Gibson RSS

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

    Travis Gibson

      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.