Forum Discussion
Ragged Hierarchy no aggregation
I have a ragged hierarchy. I'd like to provide a method that allows users to navigate the hierarchy in a matrix visual without the measures aggregating. Think of it as a lookup while navigating through the hierarchy.
Sample dataset:
Current problem:
The navigation isn't working as needed. I'm using Measure = SELECTEDVALUE( Revenue ) and Sum of Revenue = SUM(Revenue). The Revenue column cannot be aggregated.
At Net Income level, the Measure column should = 46034212
At Net Income | Income level, the Measure column should be = 13688350
At Net Income | Income level | Income/(loss), the Measure column should be = 41581397
Hi fhnj,
Thank you lbendlin, for your insights.
please refer the below link whih may help to resolve the issue
Ragged Hierarchies (Analysis Services multidimensional) | Microsoft Learn
Thank you.
5 Replies
- lbendlin
Super User
Have you considered using one of the many Balance Sheet visuals and report samples?
v-saisrao-msftCommunity Support
Hi fhnj,
Thank you lbendlin, for your insights.
please refer the below link whih may help to resolve the issue
Ragged Hierarchies (Analysis Services multidimensional) | Microsoft Learn
Thank you.- v-saisrao-msft
Hi fhnj,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
- v-saisrao-msft
Hi fhnj,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
any inputs here to resolve theissue , i am also facing same issue
