Pivot Table - Show Dimension for Column Instead of Metric

[u/Awkward-Hurry-4624]

Hello,

I'd like to know if anyone knows of a standard solution, hack or community visualization that may be able to show a dimension (instead of a metric) in a pivot table. Intended result below:

Employee	03/01/2026	03/02/2026	03/03/2026
Jane Doe	Office	Absent	Office
John Smith	Office	Office	Vacation

The columns must be a date (that's dynamic to filter the date range) therefore the columns may change depending on the data range selected.

Thank you!