Hello Experts
I've created two pivot tables from one data on one page
I have one Slicer and a Timeline to control/ Filter the data
What I need is control both pivot tables using the slicers and timeline
Is there a way I can connect both pivot tables together to both the slicer and timeline?
Your help will be much appreciated
Thanks
Rahul
I have attached a sample file
Your Actual vs Promised PivotTable was created in error.
Delete it, copy from the Actual vs Promised PivotTable and change the Column Label to "Status - Promised vs Actual".
Hi josephteh
I deleted it and redid the pivot table and i'm still getting the sae error
When you say created in error? What do you mean?
Thanks
create brand new pivot tables but before: add table to data model and make PTs using data model
datamodel.jpg
If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.
see att:
Last edited by sandy666; 07-24-2017 at 11:53 AM. Reason: image added
Hi Sandy
Thanks for that. I created a new PT as you suggested and it works like a charm
Appreciated
Rahul
You are welcome, thanks for feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks