I am currently using Excel 2013 and having a problem I can't figure out. I have 2 Pivot Tables, 1 detailing Sales and 1 detailing Spend. These 2 Tables share 3 columns. What I would like to do is use 1 Timeline to sort the data data and 2 slicers to sort the other data.
Is there a way to do this?
You could consider consolidating the Pivots into one table based on a common field & apply your slicers to that resulting pivot table.
http://www.youtube.com/watch?v=hTw-3PbYuKY
Remember you are unique, like everyone else
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks