Forum Discussion

Marcello_Canetto's avatar
Marcello_Canetto
Copper Contributor
May 08, 2024

Multiple hierarchies in pivot table rows but showing in separate columns

Hello, we are trying to find a solution for the following problem statement using hierarchies in Excel Pivot Tables. I hope the excel community can help with solutions or suggestions.   Problem St...
BI & Data Analysis
excel
power bi
Yea_So's avatar
Yea_So
Bronze Contributor
May 08, 2024
The only thing I can think of is to create a data model in excel, create explicit measures, then use cube functions to present the data analysis.

Here's a video for an example: https://youtu.be/D3RrYnthuSA