Forum Discussion
Connecting two timelines from two different pivot tables that have different data sources
Hi I have created two pivot tables from two different data sources. These data sources have one thing in common which is that both have column with date. I want to have one "master" timeline...
- How did you add the date Hierarchy to the calendar table, and what was the purpose?
NikSat When I added Table1 and Table2 to the DM, I clicked 'Date Table' on the Design tab in the Calendars group. That automatically created the Calendar table based on the dates found in other tables, including the hierarchy.
And you can update/adjust the date range if you want/need.
But the key is that you create a table containing unique dates that cover all dates in the model, and that you use the date column from the Calendar table when you create pivot tables.
- Damm Riny, you are an Excel God....... lemme Try this right away
