subtotals

[Subhash08]

Hi all, i want to add subtotals in my dynamic P & L table like in the first snap 

please help me 

thank you

[Subhash08]

@Greg_Deckler can you please share your mail ID, i will share the file. can you please check it?

[Greg_Deckler]

@Subhash08 gdeckler @ gmail

[Subhash08]

@Greg_Deckler sent a mail sir , please check sir 
my mail : business2subhash@gmail

[Subhash08]

hi @Greg_Deckler , i tried the way that you mentioned. but it is not worked. i have three hierarchy row wise 
1. product_category
2. new_category
3. line item (income, COS, profit, profit %)

can you please tell me alternative approach for this ?

[Greg_Deckler]

@Subhash08 That's just it, I don't know of another way to do it. If you can post sample data as text I can take a look.

[Greg_Deckler]

@Subhash08 Unforatunately that is not easy. Two methods are to use "Measures on rows" feature of a matrix and here is another way. The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community

Note, the article is for controlling the columns, but it's the same concept for rows.