Subtotals by level in matrix

[Chrisv013]

I want to replicate the following matrix, where I need to generate the subtotal by area at each level. Does anyone know how to replicate this? Could it be done with the original matrix or by trying another chart? 

[Greg_Deckler]

@Chrisv013 Perhaps with a disconnected table. If you provide sample data posted as text could probably be more helpful.

[Chrisv013]

Hi Greg, I can do a test with the disconnected tables. Here I share some test data. The idea is to be able to generate the subtotals by area at each level in the same matrix. Here it will be by Division and by Company, like the image.

EMPRESA	DIVISION	PRODUCTO	AREA	Sales 2023	Sales 2024
BEL	DPP	REDKEN	FRONTERA	705	456
BEL	DPP	LP	DIRECTO	115	760
BEL	DPP	LP	FRONTERA	686	330
BEL	DPP	KER	DIRECTO	679	919
BEL	DPP	KER	FRONTERA	198	456
BEL	DPP	REDKEN	DIRECTO	159	335
BEL	CPD	L'OREAL	DIRECTO	592	970
BEL	CPD	L'OREAL	FRONTERA	361	812
BEL	CPD	MAY	DIRECTO	839	881
BEL	CPD	MAY	FRONTERA	446	412
BEL	CPD	GARNIER	DIRECTO	906	811
BEL	CPD	GARNIER	FRONTERA	435	160
BEL	CPD	CORINE DE FARME	DIRECTO	524	907
BEL	CPD	CORINE DE FARME	FRONTERA	619	407