Timeline on Pivot Table not working

[Gwill1983]

Hi all,

I am trying to add a timeline to my spreadsheet to allow users to adjust the date period that they want to see data on. I will try to break down how my data is being constructed:

Workbook has 2 sheets. Dashboard & Sheet1. In Sheet1, I have a table named WIP_RAW which is pulled from a query. This query extracts data from another workbook and constructs a table of data.

In the Dashboard sheet, I have a pivot table pulling data from the WIP_RAW table.

Using the pivot table, I want to add a timeline to filter my pivot table using the 'PO Received Date' data. This data isnt selected to be visible in the pivot table, but is showing when I try to add the timeline

Once I select this option and add my timeline, the data doesnt change when I select different options in the timeline.

I have checked the formatting of the column in the original table and it is formatted as a date with the data held as a numerical date (ie one of the cells is showing 44510 when formatted as 'General', but this shows as 10/11/2021 when formatted as a 'date')

Can anybody help with any suggestions on why this wouldnt be working? I have done all of the troubleshooting that I can think of.

 

[Sergius]

Hello! Without seeing the data it's hard to say what's what. When inserting a timeline on the "analysis" tab, in the dialog box, select the field in your table on which you will build this timeline.