Hello experts!
I need you valuable help.
I have the above pivot in qlikview
| Month | Sales CY | Sales PY | m2 | Visitors |
| | 13.774.659,17 | 30.855.173,02 | 8.236,22 | 677.175 |
| Jan | 2.695.856,62 | 2.401.932,99 | 8.401,45 | 127.612 |
| feb | 1.740.020,23 | 2.012.334,00 | 8.354,19 | 90.147 |
| Mar | 1.762.776,73 | 1.636.124,54 | 8.231,69 | 92.068 |
| Apr | 2.890.977,00 | 3.245.520,45 | 8.021,08 | 137.497 |
| May | 2.532.552,55 | 2.456.297,85 | 8.091,10 | 122.356 |
| Jun | 2.152.476,04 | 2.359.258,67 | 8.351,44 | 107.495 |
| Jul | 0,00 | 2.569.794,96 | - | 0 |
| Aug | 0,00 | 1.798.450,75 | - | 0 |
| Sep | 0,00 | 2.118.124,61 | - | 0 |
| Oct | 0,00 | 2.918.765,67 | - | 0 |
| Nov | 0,00 | 3.463.481,42 | - | 0 |
| Dec | 0,00 | 3.875.087,11 | - | 0 |
| | | | |
I want to add rows in dimensions field,
I have to show the data in a table as cumulative sum of Month
I want the data to be displayed like this:
| Month | Sales CY | Sales PY | m2 | Visitors |
| | 13.774.659,17 | 30.855.173,02 | 8.236,22 | 677.175 |
| Jan | 2.695.856,62 | 2.401.932,99 | 8.401,45 | 127.612 |
| feb | 1.740.020,23 | 2.012.334,00 | 8.354,19 | 90.147 |
| 2mos | 4.435.876,85 | | | |
| Mar | 1.762.776,73 | 1.636.124,54 | 8.231,69 | 92.068 |
| 3mos | 6.198.653,58 | | | |
| Apr | 2.890.977,00 | 3.245.520,45 | 8.021,08 | 137.497 |
| 4mos | 9.089.630,58 | | | |
| May | 2.532.552,55 | 2.456.297,85 | 8.091,10 | 122.356 |
| 5mos | 11.622.183,13 | | | |
| Jun | 2.152.476,04 | 2.359.258,67 | 8.351,44 | 107.495 |
| 6mos | 13.774.659,17 | | | |
| Jul | 0,00 | 2.569.794,96 | - | 0 |
| 7mos | 13.774.659,17 | | | |
| Aug | 0,00 | 1.798.450,75 | - | 0 |
| 8mos | 13.774.659,17 | | | |
| Sep | 0,00 | 2.118.124,61 | - | 0 |
| 9mos | 13.774.659,17 | | | |
| Oct | 0,00 | 2.918.765,67 | - | 0 |
| 10mos | 13.774.659,17 | | | |
| Nov | 0,00 | 3.463.481,42 | - | 0 |
| 11mos | 13.774.659,17 | | | |
| Dec | 0,00 | 3.875.087,11 | - | 0 |
| 12mos | 13.774.659,17 | | | |
I really appreciate any help you can provide!!
