Hi all,
I have 1 dimension (Category) with these values:
B1,B2,B3,E1,E2,E3,F
is there a way to achieve a pivot table like this in QlikView?
Category | France | UK |
B1 | 1.000,00 € | 500,00 € |
B2 | 2.000,00 € | 1.500,00 € |
B3 | 3.000,00 € | 2.000,00 € |
Group B | 6.000,00 € | 4.000,00 € |
E1 | 500,00 € | 600,00 € |
E2 | 500,00 € | 600,00 € |
E3 | 500,00 € | 600,00 € |
Group E | 1.500,00 € | 1.800,00 € |
F | 7.500,00 € | 4.500,00 € |
TOTAL | 15.000,00 € | 10.300,00 € |
Best regards.