Forum Discussion
subtotals
Hi all, i want to add subtotals in my dynamic P & L table like in the first snap
please help me
thank you
6 Replies
- Greg_Deckler
Community Champion
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.
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 can you please share your mail ID, i will share the file. can you please check it?
- Greg_Deckler
Subhash08 gdeckler @ gmail
Greg_Deckler sent a mail sir , please check sir
my mail : business2subhash@gmail
