Forum Discussion
Matrix dynamic rows / multiple hierarchy issue
aniket_kumbhar So this "product" row is not part of the date hierarchy? So basically you have two separate hierarchies in a single visual? That seems weird and unintuitive to me as a report user. Pretty certain you cannot do that in a standard matrix visual so I would recommend a custom visual from AppSource or maybe R or Python. The other way would be to create a table with your row headers and construct a measure similar to:
Community Championaniket_kumbhar So this "product" row is not part of the date hierarchy? So basically you have two separate hierarchies in a single visual? That seems weird and unintuitive to me as a report user. Pretty certain you cannot do that in a standard matrix visual so I would recommend a custom visual from AppSource or maybe R or Python. The other way would be to create a table with your row headers and construct a measure similar to: