Need rows grand total in first column when we have hierarchy in Matrix visual?

[suneelkethagani]

Hi Guys, Good Morning All

I hope you are doing well.

Need rows grand total in first column when we have hierarchy in Matrix visual?

I have 6 dimension columns in Rows Field-well and 2 dimension columns (Employee Name and Position) in Columns Field-well. I need Grand Rows Grand Total in First Column. Those 2 columns Employee Name and Position are also arranged based on specific order in this context.

Please suggest me, how can I achieve this?

Thank you in advance....

Suneel

[amitchandak · Accepted solution]

@suneelkethagani , You can move subtotal to top or bottom as per need, using Sub Total Position , but this do not change grand total position

You can log an idea for grand total: https://ideas.powerbi.com/ideas/