Hello Experts,
I'm new to Qlik. Currently I'm facing a percentage rollup at Year level which is in the column as part of pivot view.
Below is the example of the current scenario.
Need Average of each Dim1 value at each year level. Not complete total of the value avg.
Current Output:
| | | | Year | | | |
| Dim 1 | Total | 2020 | 2019 |
| | value | Percentage | value | Percentage | value | Percentage |
| Total | 220 | 100.00 | 100 | 45.45% | 120 | 54.55% |
| A | 60 | 27.27 | 20 | 9.09% | 40 | 18.18% |
| B | 20 | 9.09 | 10 | 4.55% | 10 | 4.55% |
| C | 80 | 36.36 | 40 | 18.18% | 40 | 18.18% |
| D | 60 | 27.27 | 30 | 13.64% | 30 | 13.64% |
Expected output is below.
| | Year | | | |
| Dim 1 | 2020 | 2019 |
| | value | Percentage | value | Percentage |
| Total | 100 | 100% | 120 | 100% |
| A | 20 | 20.00 | 40 | 33.33 |
| B | 10 | 10.00 | 10 | 8.33 |
| C | 40 | 40.00 | 40 | 33.33 |
| D | 30 | 30.00 | 30 | 25.00 |
I've search in the community that suggests we can do this at row total level, but haven't yet worked out how to do this at column individual value level.
Please suggest me with your input to get some final solution.
