Here is a Qlikview Document belonging to the discussions about totals in a Pivottable
And Data from an Excel sheet
| | Interval | -999999 | -999999 | < -14 Tage | < -14 Tage | -14<=Tage<=-8 | -14<=Tage<=-8 | -7<=Tage<=-2 | -7<=Tage<=-2 | -1<=Tage<=+1 | -1<=Tage<=+1 | +2<=Tage<=+7 | +2<=Tage<=+7 | +8<=Tage<=+14 | +8<=Tage<=+14 | > +14 Tage | > +14 Tage |
| Booking month | Total Amount | Sales | Share in % | Sales | Share in % | Sales | Share in % | Sales | Share in % | Sales | Share in % | Sales | Share in % | Sales | Share in % | Sales | Share in % |
| Total | | 745 | 0,0887% | 1.500.214 | 4,9199% | 2.359.794 | 7,6484% | 6.642.550 | 21,4939% | 8.290.568 | 26,8350% | 5.117.560 | 16,5587% | 2.694.278 | 8,7178% | 4.299.911 | 13,9130% |
| Jan | 3.351.670 | 294 | 0,1261% | 119.340 | 3,5606% | 154.330 | 4,6046% | 709.790 | 21,1772% | 728.402 | 21,7325% | 550.972 | 16,4387% | 422.406 | 12,6028% | 666.135 | 19,8747% |
| Feb | 3.905.435 | - | - | 148.199 | 3,7947% | 291.576 | 7,4659% | 809.395 | 20,7248% | 931.355 | 23,8477% | 550.351 | 14,0919% | 362.604 | 9,2846% | 811.956 | 20,7904% |
| Mrz | 4.486.280 | - | - | 371.285 | 8,3713% | 306.944 | 6,9207% | 1.045.760 | 23,3102% | 1.077.939 | 24,0275% | 707.030 | 15,7598% | 406.803 | 9,0677% | 570.519 | 12,7170% |
| Apr | 3.463.823 | 22 | 0,0110% | 167.557 | 4,9618% | 175.882 | 5,0777% | 610.485 | 17,6246% | 923.070 | 26,6489% | 695.541 | 20,0802% | 373.414 | 10,7804% | 517.852 | 14,9503% |
| Mai | 4.058.615 | - | - | 182.421 | 4,7344% | 379.724 | 9,3560% | 885.234 | 21,8112% | 1.252.881 | 30,9538% | 643.074 | 15,8447% | 214.013 | 5,2730% | 501.269 | 12,3507% |
| Jun | 3.997.630 | - | - | 245.661 | 6,1452% | 409.832 | 10,2519% | 780.682 | 19,5286% | 1.060.244 | 26,5218% | 700.438 | 17,5213% | 284.193 | 7,1090% | 516.579 | 12,9221% |
| Jul | 4.237.035 | - | - | 156.645 | 3,7583% | 399.791 | 9,4385% | 925.823 | 21,8574% | 1.195.599 | 28,2178% | 771.398 | 18,2061% | 382.259 | 9,0219% | 405.518 | 9,5708% |
| Aug | 3.405.132 | 430 | 0,1046% | 109.105 | 3,2041% | 241.713 | 7,0985% | 875.380 | 25,7077% | 1.121.078 | 32,9232% | 498.756 | 14,6472% | 248.586 | 7,3003% | 310.083 | 9,1063% |
| | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | |
| Months | Amounts | Percentages | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | |
| Jan | 3.351.670 | 100,1173% | | | | | | | | | | | | | | | |
| Feb | 3.905.435 | 100,0000% | | | | | | | | | | | | | | | |
| Mrz | 4.486.280 | 100,1742% | | | | | | | | | | | | | | | |
| Apr | 3.463.823 | 100,1238% | | | | | | | | | | | | | | | |
| Mai | 4.058.615 | 100,3239% | | | | | | | | | | | | | | | |
| Jun | 3.997.630 | 100,0000% | | | | | | | | | | | | | | | |
| Jul | 4.237.035 | 100,0708% | | | | | | | | | | | | | | | |
| Aug | 3.405.132 | 100,0920% | | | | | | | | | | | | | | | |
