Pivots Table filter

[so_nice3]

Hi,

I have 3 sheets in my excel worksheet.

1. Org
2. DataSource
3. Pivots Table

My Pivot table will get the data from the DataSource sheet. I will like to have the filter of the Pivot Table from one of the cell in Org Sheet.

How can I do that?

Thanks.

[cbatrody]

Hi,

Instead you can use GETPIVOTDATA function and get the necessary details from Pivot Table Sheet to Org Sheet.

[:) Sixthsense :)]

Just use a helper column in Pivot Source Range and use formula in the helper column like

=cell in Org Sheet=your Source Data Column Cell value ref

=IF(Org!A2=SourceSheet!B2,"Show","Hide")

Include that helper column range in your Pivot Source Range and leave the Helper column name in Pivot Report Filter area.

Now select Show in the report filter and untick the Hide drop down value.

Your pivot table will display the data based on the value of Org Sheet cell. But you have to refresh the pivot on each change in that cell value