Forum Discussion
Subtotals by level in matrix
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 a...
Anonymous Perhaps with a disconnected table. If you provide sample data posted as text could probably be more helpful.
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 |