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.
