Using a timeline to filter by column header

[Kingsof82]

Hi,

I'm designing a document for users in my company to be able to track staff member supervisions. There are several types of supervision that each staff member may have, and utilising SUMPRODUCT and assistance from this community, I've totalled these into one table, see example:

I have date columns running up until the end of 2028 and was hoping to set up a pivot table with a timeline that uses the column headers as the reference point, so users could check how many supervisions each staff member has received within a specific timeframe and check these against policy standards.

However, I'm unable to do so as the value fields are not formatted as dates. Is there a way for this to work or have I wasted my time in setting up the table as above?

Any help or advice greatly appreciated, thanks.

 

[user29383902]

Are you sure if these values are formatted as date it would work? If yes, then I could help you format those values as date.

 

[RoryA]

That layout is not ideal as a data source for a pivot table as each date would be a separate field, not a value within one field. You could use Power Query to unpivot the table in a query and then build the pivot table directly off that. Doing it that way, you can also convert the headers to real date values.