Feb 28 2023 09:48 PM
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.
Mar 06 2023 12:11 PM
SolutionYou 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
Mar 06 2023 12:11 PM
SolutionYou 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