Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, i want to add subtotals in my dynamic P & L table like in the first snap
please help me
thank you
@Greg_Deckler can you please share your mail ID, i will share the file. can you please check it?
@Subhash08 gdeckler @ gmail
@Greg_Deckler sent a mail sir , please check sir
my mail : business2subhash@gmail
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 ?
@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.
@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.
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
85 | |
52 | |
37 | |
23 |