Hi,
I'm attempting to create a pivot table/chart and associated timeline from a table which has 50+ columns containing dates. I'd like to be able to incorporate all of these date fields into one timeline slicer, which can then be used by the end user to view summary information.
The date columns are chronologised and fed from four other data sheets. When I insert the pivot table, I am able to apply a timeline to the first date column, but not others, even though they and all the feeding cells are formatted as dates (The first column is fed using the MIN values function, whereas the others required an AGGREGATE function in order to return the next date chronologically).
Hopefully this is a possibility and any help is greatly appreciated
Thanks
I'm attempting to create a pivot table/chart and associated timeline from a table which has 50+ columns containing dates. I'd like to be able to incorporate all of these date fields into one timeline slicer, which can then be used by the end user to view summary information.
The date columns are chronologised and fed from four other data sheets. When I insert the pivot table, I am able to apply a timeline to the first date column, but not others, even though they and all the feeding cells are formatted as dates (The first column is fed using the MIN values function, whereas the others required an AGGREGATE function in order to return the next date chronologically).
Hopefully this is a possibility and any help is greatly appreciated
Thanks
