This requires data join structure change.
Could you please attach original excel file?
Thanks for looking into it. I have now attached my Excel sheet.
2 of 2 people found this helpful
Have you tried using sets with your hierarchy? It looks quite a bit like Excel in the end. Here's a link to the TC19 session by Filippos Lymperopoulos where he demostrates Aysemetrical Hierarchies using sets. The whole session is worth watching...but I've bookmarked the video to start at the spot you need right now:
Thanks for a interesting input. I have watchet the video and got inspired to build on this idea.