Forum Discussion
Group column in the Matrix table
Hi, I am trying to build a matrix table, but I am wondering is it possible that I could format the table like this:
(No expand or collapse sign on "Country" & "Date" columns but only on "Item" because the first 2 columns are necessary info but "ID is less important for showing in the table)
| Country | Date | Item | ID | Sales |
| US | 2-Feb | A | ||
| A1 | 10 | |||
| A2 | 10 | |||
| HK | 2-Feb | B | ||
| B1 | 5 | |||
| B2 | 5 | |||
| B3 | 5 | |||
| Japan | 2-Feb | C | ||
| C1 | 10 |
Thanks if there is any idea
Hi, Anonymous ;
You could create a Hierarchy as Item and ID, then create a measure.
1.create a Hierarchy.
2.create a measure.
The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
You could create a Hierarchy as Item and ID, then create a measure.
1.create a Hierarchy.
2.create a measure.
The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.v-yalanwu-msft this is a special trick
- lbendlin
Super User
It's kinda sorta possible when you switch the values to "show on rows" but frankly it will be a lot of effort for not much of a gain. I would change my requirements if I were you.
