I tried seeking help earlier but struggled at explaining what I'm trying to accomplish. In an effort to simply my issue, I've relabeled my pivot table to represent sport statistics. It's not the best example but I'll try.
Below is an image of my pivot table where I am trying to display player statistics such as goals, assists, blocks, fouls, & checks for players for 8 games. How I want this to be displayed is as a list instead of a table which is has all games grouped under each statistic like you see in the screenshot (Why? It makes more sense for my actual purpose for the table).
What I want to do now is filter out all the games that don't have a value next to it. If player 1 (or student 1) doesn't have any assists in games 2,3,4,5,7, or 8, I don't want them displayed in the table. I've tried using a simple heading filter but it only filters out the zero value rows from the first group/ statistic "goals." I've tried putting the statistics also in the filters section of the PivotTable Fields. When I do this and try filter out zeros under the "goals" section, it does filter out the games with zero values in that section, but it also removes those games from all the other sections even though that player might have non-zero values for assists, blocks, etc. in those games.
Finally I've played around with Power Query but that won't let me filter between players quickly when I put in a splicer.
Here is a link to my workbook if you'd like to play around with it: Example.xlsx
Thanks in advance for any effort you make towards problem solving this. Sorry for having picky format.
Below is an image of my pivot table where I am trying to display player statistics such as goals, assists, blocks, fouls, & checks for players for 8 games. How I want this to be displayed is as a list instead of a table which is has all games grouped under each statistic like you see in the screenshot (Why? It makes more sense for my actual purpose for the table).
What I want to do now is filter out all the games that don't have a value next to it. If player 1 (or student 1) doesn't have any assists in games 2,3,4,5,7, or 8, I don't want them displayed in the table. I've tried using a simple heading filter but it only filters out the zero value rows from the first group/ statistic "goals." I've tried putting the statistics also in the filters section of the PivotTable Fields. When I do this and try filter out zeros under the "goals" section, it does filter out the games with zero values in that section, but it also removes those games from all the other sections even though that player might have non-zero values for assists, blocks, etc. in those games.
Finally I've played around with Power Query but that won't let me filter between players quickly when I put in a splicer.
Here is a link to my workbook if you'd like to play around with it: Example.xlsx
Thanks in advance for any effort you make towards problem solving this. Sorry for having picky format.