Sub Group under main group

[amitm]

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

[v-yuezhe-msft · Accepted solution]

@amitm,

Create Matrix visuals as below in Power BI Desktop, and use the highlighted button to expand the Matrix visuals.



Regards,
Lydia

[amitm]

Thank you very much. Superb. Truly helpful.