How to have pivot table downloaded to a spreadsheet as it is.
Right now, I have data pivot table in the report as the x-axis is week dates, the y-axis is the metric name, and the cell shows the numbers.
However, when I try to export the data, I got the metric/date specific data as below:
Date | value
Metric1 | Mar 30, 2026 | 1000
Metric1 | Mar 23, 2006 | 1001
Metric1 | Mar 16, 2006 | 1002
Metric2 | Mar 30, 2026 | 2000
Metric2 | Mar 23, 2006 | 2001
Metric2 | Mar 16, 2006 | 2002
However, what I expected is something like
Mar 30, 2006 | Mar 23, 2006 | Mar 16, 2006
Metric1 | 1000 | 1001 | 1002
Metric2 | 2000 | 2001 | 2002
Any way to export the table data as it is?