Exclude hidden rows in pivot table

[khenn]

I have a bunch of filtered/hidden rows in my source sheet for a pivot table. I do not want these rows included in my pivot table calculations. Is this possible?

 

[iliace]

You can add the fields on which you're filtering and their filter criteria to the pivot table, then drag them to the page field. This will exclude them.

If the criteria are complex, consider adding a new field column in your source data then using that to filter the pivot table records.

 

[khenn]

Fantastic! That worked perfectly! Thanks so much for your help!

 

[iliace]

Well, fantastic it is! I'm glad that something so non-specific was so easy to implement for you.

 

[khenn]

I actually used your second option and created a field that indicated if it was a visible field or not. Then included that field in the pivot table and filtered the pivot table on that field. I was unaware that you could actually filter on pivot tables! Thats a huge time saver! Thanks again!

 

[chirag050675]

I actually used your second option and created a field that indicated if it was a visible field or not. Then included that field in the pivot table and filtered the pivot table on that field. I was unaware that you could actually filter on pivot tables! Thats a huge time saver! Thanks again!

Dear All Users

You can add slicer after create pivot table, select field you want to filter as slicer ,you can select multiple values of slicer, (Slicer available in on & after office version 2007) now you can see only selected data (filtered) from slicer in pivot Table.

you can see more usage of slicer in https://www.youtube.com/watch?v=p0U9oeRggFk

Hope this helps,

Regards,

Chirag Raval