creating a pivot table from a table...

[konijay]

Good day all


I have raw data and turned it into a TABLE.


then I created a pivot table from it.


then I filter out something from the TABLE. It's now hiding some rows.


But the pivot table does not reflect that filtered info from the table...it's also reading rows that are hiding.


How can pivot table reflect filtered data from the table?


thanks

 

[NARAYANK991]

Hi ,


Do you think this link will help ?


http://www.excelbanter.com/showthread.php?t=248146


Narayan

 

[Luke M]

You can't, directly. You either need to filter things in the PivotTable(PT) rather than in your data, or you can add a helper column with something like this:

=SUBTOTAL(103,A2)


This formula will evaluate to 1 for cells that have data are are not hidden, and 0 for any hidden row. Once you add the name of helper column to your PT, you could set it as a PageField item and filter it to 1. That way, (after refreshing PT) you'll only see unfiltered table data in the PT.