Forum Discussion
Multiple tier rollup in Matrix Preview
HI tnoflahc,
I think you can try to path function to analysis your columns.
1. Use path to analysis hierarchy relationhship.
2. Create calculated columns based on above level.
3. Use these columns to build custom hierarchy.Reference link:
Creating a user hierarchy from a manager column to use as hierarchy slicer
Regards,
Xiaoxin Sheng
Hi Anonymous, thanks for the tip! So, using the first link, I figured out how to structure my tables in a way to kind of produce the results I needed. I now have something like this:
Date || City || State || Region || $Amount
And that seems to be working as expected.
Thanks again!
Can someone help me with a very similar problem? It's an organizational hierarchy, so there are different levels under each person. I have the data flattened out with a path (CEO|ManagerName|SupervisorName|ResourceName|) but I'm not clear on how to use this in the Matrix visual to expand each level and display corresponding values.....