Dear Qlik Community,
| Status_VAVE | BU_VAVE | [VAVE Category 1_VAVE] | total | Calendar Year/Month | Jan 2021 | Feb 2021 | Mar 2021 | Apr 2021 | May 2021 | Jun 2021 | Jul 2021 | Aug 2021 | Sep 2021 | Oct 2021 | Nov 2021 |
| YTD | | | | 79 M¥ | 65 M¥ | 83 M¥ | 102 M¥ | 104 M¥ | 148 M¥ | 84 M¥ | 68 M¥ | 52 M¥ | 30 M¥ | 24 M¥ |
| VSG5- Monitoring | IBU | Material | Total | 79 M¥ | 65 M¥ | 83 M¥ | 102 M¥ | 104 M¥ | 148 M¥ | 84 M¥ | 68 M¥ | 52 M¥ | 30 M¥ | 24 M¥ |
| single: Carryover | 79 M¥ | 65 M¥ | 83 M¥ | 102 M¥ | 104 M¥ | 148 M¥ | 84 M¥ | 68 M¥ | 52 M¥ | 30 M¥ | 24 M¥ |
In the above table, YTD is showing the total of the columns(Unfortunately there is only one value in the columns), but I want it to display the running total/cumulative sum in YTD(The table is changed by the Qlik board due to some errors, assume it is a pivot and just focus on the first row 'YTD').
Can someone help me?
Thanks,
Akash
