Forum Discussion
Table creation based on hierarchy without matrix
Hello Everyone,
I have requirement to create table or matrix with hierarchy.
Need to populate the rows next each other without drill down or drill through based on the slicer selection.
1st would be country, 2nd would be district total based on the district slicer, from 3rd row need top 10 representative under the district based on the selection.
Example:- Country|Districts total|Rep1|Rep2|.....|Rep10
3 Replies
PaulDBrownCommunity Champion
If you use a matrix, the fields will be grouped by the order you add the fields to the row bucket. If you use a table visual, you can sort the rows by sorting using Shift + click in progression
Paul, my situation is. I have measures in Columns and needs country district and reps in rows. Am attaching the image from excel
- v-easonf-msft
Community Support
Hi, Naveen_BN
Not fully sure what you want.
Is this what you want?Try to turn off the stepped layout of Row Headers.
Best Regards,
Community Support Team _ Eason
