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 ...
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
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