Forum Discussion
Grouping Matrix table
Below is my source Data:
| Store number | Style | Group | TY Unit | LY Unit | TY INVENTORY | LY INVENTORY |
| 1 | apple | F | 5 | 5 | 8 | 17 |
| 1 | watermelon | F | 7 | 8 | 7 | 14 |
| 1 | blueberry | F | 8 | 7 | 6 | 12 |
| 1 | pear | F | 10 | 4 | 2 | 16 |
| 2 | apple | F | 3 | 6 | 3 | 25 |
| 2 | watermelon | F | 7 | 9 | 23 | 14 |
| 2 | blueberry | F | 6 | 3 | 82 | 9 |
| 2 | pear | F | 5 | 2 | 32 | 8 |
| 3 | apple | NF | 4 | 8 | 20 | 13 |
| 3 | watermelon | NF | 1 | 5 | 23 | 11 |
| 3 | blueberry | NF | 7 | 1 | 32 | 10 |
| 3 | pear | NF | 8 | 2 | 33 | 8 |
| 4 | apple | NF | 2 | 5 | 25 | 9 |
| 4 | watermelon | NF | 6 | 5 | 78 | 8 |
| 4 | blueberry | NF | 6 | 6 | 54 | 15 |
| 4 | pear | NF | 6 | 4 | 32 | 4 |
"TY INV VS LY" and "TY UNIT VS LY" are new measures added that calculate the change. However I can only create a Matrix below by dragging "Group" to the Columns section and "TY INV VS LY" and "TY UNIT VS LY" to the Values section.
I would like to use "TY INV VS LY" and "TY UNIT VS LY" as the group and "F" & "NF" as values names.
Essentially stwitching "Columns" names and "Values" names and group "TY INV VS LY" columns together and "TY UNIT VS LY" columns together.
My ideal table is like this :
Is there a way to achiech this in BI?
Any comments or suggestions would be appreciated!
1 Reply
Anonymous , if you need to measure the above dimension, you need to create a calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
