Forum Discussion
Solved
Sub Group under main group
I am a new user of Power BI
Can someone help creating data subgroup under main group like below pivot output
Sum of RevenueSum of RevenueGrand Total22075Grand Total22075
| Existing Data | Required Output | Required Output | ||||||
| PrinCode | AgentCode | Revenue | ||||||
| Principal 1 | Agent A | 27 | Row Labels | Total | Row Labels | Total | ||
| Principal 1 | Agent B | 126 | Agent A | 6144 | Principal 1 | 262 | ||
| Principal 1 | Agent C | 43 | Principal 1 | 93 | Agent A | 93 | ||
| Principal 1 | Agent A | 66 | Principal 2 | 1728 | Agent B | 126 | ||
| Principal 2 | Agent C | 390 | Principal 3 | 3943 | Agent C | 43 | ||
| Principal 2 | Agent C | 4376 | Principal 4 | 380 | Principal 2 | 6494 | ||
| Principal 2 | Agent A | 654 | Agent B | 10798 | Agent A | 1728 | ||
| Principal 2 | Agent A | 876 | Principal 1 | 126 | Agent C | 4766 | ||
| Principal 2 | Agent A | 198 | Principal 3 | 2729 | Principal 3 | 6672 | ||
| Principal 3 | Agent B | 2387 | Principal 4 | 7943 | Agent A | 3943 | ||
| Principal 3 | Agent B | 342 | Agent C | 5133 | Agent B | 2729 | ||
| Principal 3 | Agent A | 678 | Principal 1 | 43 | Principal 4 | 8647 | ||
| Principal 3 | Agent A | 3265 | Principal 2 | 4766 | Agent A | 380 | ||
| Principal 4 | Agent A | 124 | Principal 4 | 324 | Agent B | 7943 | ||
| Principal 4 | Agent A | 256 | Agent C | 324 | ||||
| Principal 4 | Agent B | 7689 | ||||||
| Principal 4 | Agent B | 254 | ||||||
| Principal 4 | Agent C | 126 | ||||||
| Principal 4 | Agent C | 198 | ||||||
| 22075 |
Thank you in advance
amitm,
Create Matrix visuals as below in Power BI Desktop, and use the highlighted button to expand the Matrix visuals.
Regards,
Lydia
