Forum Discussion
Grouping in Matrix
Hi Anonymous
First make sure your dataset structure like below
Then add "parent" and "child" column to the Row field of a Matrix visual, then click on the fourth icon to let the row show at the lowest level.
Additional you could select Rows Headers->Stepped layout, turn off this option, you could see the picture as below.
If you have any question, please feel free to ask me.
Best Regards
Maggie
Hi Anonymous
First make sure your dataset structure like below
Then add "parent" and "child" column to the Row field of a Matrix visual, then click on the fourth icon to let the row show at the lowest level.
Additional you could select Rows Headers->Stepped layout, turn off this option, you could see the picture as below.
If you have any question, please feel free to ask me.
Best Regards
Maggie
Thank you very much Maggie for your kind reply to my question. Keep answering to all of our questions.
God bless you and family,
Praveen.
how do you write a measure for custom values for child in this structural grouping?
The grouping has no effect on the rows, and you can consider that a measure will be calculated as if all columns were populated in a table. If you're looking to do a different calculation depending on hierarchy level, you'll want to use a switch based on ISINSCOPE.
Hi ,
Grouping works perfectly fine, but I wanted to sort the "parent" column in a particular order. So, I created supporting table with ranking and pulled the respective column from the newly created table into the matrix. Now smth went wrong and grouping does not work any more. I cant figure out why.. puzzled. If any one could help!Matrix VisualFieldsFields details
Dear All,
I'm having two tables from which I have created the above Matrix visuals but the requirment is that the fields are not coming in +- (expand/shrink) at Row Level, also I have turned on Values"Show on Rows" . Please note my Values are in seperate measure so that can not be moved to Row level
Best Regards
Manik NagMillion Thanks
