• 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.

Slicer & Pivot Tables

R

RDaga

Member
Hi Friends,

I have been stuck in a problem and have been looking for solution for quite some time. I have tried reaching out to my friends and also did some searching on Google but was not able to find the solution. It will be of great help if someone can help me out.

I have an excel file which has a normal pivot table and another one as a Data Model pivot table. Right now if I use a slicer I need two slicer. Is there a way I can just create one slicer to change the month and it will update both the pivot tables.
 
A slicer only works on multiple pivots when these pivots share the same picot cache (normal pivots) or the same data model.

You can add the raw data of your normal pivot into the data model and make a calender table so the time dimension is shared across your model. Making the slicer on that table will then do what you are after.

But depending on your data structure this can be easy or hard, or maybe even impossible.
 
You must log in or register to reply here.
Back
Top