Excel Like Format with Groups & Subtotals in Powerbi

[topkapi]

Hi All,

I have a table with multiple columns. I need to produce Excel like format in Powerbi with SUBGROUP TOTLS AND GRAND TOTAL. It's not matrix report as all these are columns. Order of c4-SUM-1, and C5-SUM-2 is important. Everything should look like similar.

Thanks

[v-piga-msft]

Hi @topkapi,

How do you group the data and the c4-SUM-1, and C5-SUM-2 are the calculated columns you want to created in Power BI ?

It seems that you want to create a table with the columns like the output you uploaded?

It will be better for understanding if you could replace the XX to numbers.

Best Regards,

Cherry