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
- The calendar column is creating entries from 1st Jan to 31st Dec and every entry starts at 12AM, but my entries in the pivot tables are in the format dd-mm-yyyy hh:mm:ss, where in the date column time is also being recorded like 06:40:54 etc, do you think this is causing an error, even the timeline created from Calendar Table Didn't work :'(
NikSat You can change the format for the date column in the DM.
Otherwise send me your file in a direct message.