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 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!