Dear all,
I have an Excel database with several information and the goal of it is to produce a daily/monthly report.
I have a little problem... the thing is:
- I have several Pivot Tables linked by "Date", i.e., when I define a date it applies to many tables
- What I want now is from one "date linked pivot table", link to a different pivot table based on that information
Is it possible?
Attached are some pics to help to understand
Thanks to everybody
If the pivot tables are all built from the same data source you can use a slicer. Select one of the tables, go to the Insert Ribbon and select slicer - choose the fields you want. Once you create the slicer, click on it and you will get an Options Ribbon. On the options ribbon, select Report Connections and click on the reports you want to bind to the slicer.
Slicers can even select on items not shown on the pivot table but included in the data.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks