• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple Pivots

Hi All,


Please refer to the attached book containing 2 sheets Pivot and Data.

I have 3 pivots on Pivot sheet with Report filter as Company in all three.
Also I have applied a validation on yellow cell in Pivot sheet.

Now what I want is when I select a company from yellow cell all pivots will gets refresh with that report filter.

I have searched a macro solution for that which is a bit tedious to apply and is not feasible in my organization.

Do anyone have a non-macro solution for that ?

Please help.
 

Attachments

  • multi-pivot_one refresh.xlsx
    215.2 KB · Views: 7
Hi,

I have added a slicer which can change all 3 filters by one filter. Please check and let me know if its working

Regards
Deepa 9

Hi Deepa,

Its working fine can u plz explain the steps of connecting slicer to multiple pivots.

When I go to slicer option and report connections only one pivot is showing.
 
Last edited:
Hi Ali ,

The problem occurs when you have inserted all the pivot tables and then you have created the slicer for any one pivot table ; if you create the first pivot table , insert the slicer for it , and then create the second pivot table , you can use the first slicer for the second pivot table.

See the post here :

http://blog.contextures.com/archive...ultiple-pivot-tables-with-excel-2010-slicers/

I followed the post , and everything worked the way it has been mentioned.

See your file.

Narayan
 

Attachments

  • multi-pivot_one refresh.xlsx
    160.8 KB · Views: 4
Back
Top