Forum Discussion
Solved
Display multiple values under single column heading in pivot table
I would like to create a pivot table that looks like this:
But I cannot seem to display multiple values in rows by month. They only alternate columns like this:
Is this possible using a pivot table? Thank you.
You cannot put aggregated values (aka Measures) on Rows of a PivotTable
An option with 365/Windows, Table(s) in the Data Model (aka Power Pivot), a hidden helper sheet and a few LAMBDAs that involve some of the CUBE functions
1 Reply
You cannot put aggregated values (aka Measures) on Rows of a PivotTable
An option with 365/Windows, Table(s) in the Data Model (aka Power Pivot), a hidden helper sheet and a few LAMBDAs that involve some of the CUBE functions