dougemac
New member
- Joined
- Mar 18, 2022
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 265
I'm a teacher and I'm trying to develop a dashboard to report student progress for my students. I'm happy with the progress I've made in developing it but I am stuck filtering out zero values from my pivot table. I'm using a table with multiple-level rows with the values being organized first, then assignments. I'm using the table filter to filter out the zero values which seems to work for the first set of values but it won't filter them out in the subsequent rows in the next section.
If I set up my table differently, I don't have this problem but in terms of what I need to report, this format is the best and I'd like to see if I can problem solve this filtering issue first before adapting my report format. Is there a way to filter the entire table while it has this format?
If I set up my table differently, I don't have this problem but in terms of what I need to report, this format is the best and I'd like to see if I can problem solve this filtering issue first before adapting my report format. Is there a way to filter the entire table while it has this format?