SOLVED

Display multiple values under single column heading in pivot table

Copper Contributor

I would like to create a pivot table that looks like this:

pivot.jpg

But I cannot seem to display multiple values in rows by month. They only alternate columns like this:

61ee307c-17c9-45cc-9700-a79a32a9ef91.jpg
Is this possible using a pivot table? Thank you.

1 Reply
best response confirmed by ytulparslp (Copper Contributor)
Solution

@ytulparslp 

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

 

Sample.png

1 best response

Accepted Solutions
best response confirmed by ytulparslp (Copper Contributor)
Solution

@ytulparslp 

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

 

Sample.png

View solution in original post