Dear QlikView-Forum,
we want to copy an excel-pivot into QlikView and i am getting Problems with the cumulative percentage.
We have a pivot like this:
| Region | Product | SALES | CUMULATIVE PERCENTAGE |
| TOTALS | | 430.000,00 € | 100,00% |
| Netherlands | TOTALS | 250.000,00 € | 58,14% |
| Netherlands | A | 100.000,00 € | 40,00% |
| Netherlands | C | 150.000,00 € | 60,00% |
| Austria | TOTALS | 180.000,00 € | 41,86% |
| Austria | A | 50.000,00 € | 27,78% |
| Austria | B | 70.000,00 € | 38,89% |
| Austria | D | 60.000,00 € | 33,33% |
How to do? Many thanks in advance :-))
