Subtotal

[Arshad313]

Hi All.

Thanks in advance. I am new user and would like to know is there an option to show 2 subtotals in the table below? I basically wants to convert the table1 to table 2? to show exluding and including one of the BU.. Please advise

Table 1
Sector	Health	Health	CM	CM	FS	FS	EUR	EUR	Other	Other
BU	Actuals	Budgets	Actuals	Budgets	Actuals	Budgets	Actuals	Budgets	Actuals	Budgets
A	100	150	160	240	256	384	410	614	655	983
B	200	180	320	288	512	461	819	737	1,311	1,180
C	250	300	400	480	640	768	1,024	1,229	1,638	1,966
D	400	488	640	781	1,024	1,249	1,638	1,999	2,621	3,198
E	450	454	720	726	1,152	1,162	1,843	1,860	2,949	2,975
Z	-200	-400	-320	-640	-512	-1,024	-819	-1,638	-1,311	-2,621
Total	1,200	1,172	1,920	1,875	3,072	3,000	4,915	4,801	7,864	7,681
Table 2 (Desired result)
Sector	Health	Health	CM	CM	FS	FS	EUR	EUR	Other	Other
BU	Actuals	Budgets	Actuals	Budgets	Actuals	Budgets	Actuals	Budgets	Actuals	Budgets
A	100	150	160	240	256	384	410	614	655	983
B	200	180	320	288	512	461	819	737	1,311	1,180
C	250	300	400	480	640	768	1,024	1,229	1,638	1,966
D	400	488	640	781	1,024	1,249	1,638	1,999	2,621	3,198
E	450	454	720	726	1,152	1,162	1,843	1,860	2,949	2,975
Total exluding Z	1,400	1,572	2,240	2,515	3,584	4,024	5,734	6,439	9,175	10,302
Z	-200	-400	-320	-640	-512	-1,024	-819	-1,638	-1,311	-2,621
Total including Z	1,200	1,172	1,920	1,875	3,072	3,000	4,915	4,801	7,864	7,681

[v-easonf-msft]

Hi , @Arshad313 

Powerbi cannot directly create such an effect on a matrix visual.

As a workaround,you can try to  create two matrix  table which applied different filters. Then combine the two visuals through the "Group" button.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Arshad313 , No can not show two sub total