Hi
I am unable to achieve correct Pivot Table total in Qliksense November 2020 version. Below is how the table looks :
| | | May | Jun | Jul | Augu | Sep |
| Company name | ID | | | | | |
| OOPA | 3456 | | | 3.75 | | |
| FEDA | 2314 | 2 | 1 | | | 0.25 |
| RATE | 5678 | | | | 2 | 3.75 |
| NOVA | 4671 | | 2 | | | |
| Total | | 2 | 3 | 3.75 | 2 | 4 |
Dimension - Company name, ID and month
Expression - sum(aggr(rangemin(count(id)-rangesum(before(column(1),1,columnno(Total), count(id)/4)
This expression changes the total for certain columns for eg : Nova for June is 2 but shows total as 3. With aggr function row level values also changes for some months. eg actual value for FEBA is 3 but it is showing 1 for June. Expected output of this table is
| | May | Jun | Jul | Augu | Sep |
| Company name | | | | | |
| OOPA | | | 3.75 | | |
| FEDA | 2 | 3 | | | 0.25 |
| RATE | | | | 2 | 3.75 |
| NOVA | | 2 | | | |
| Total | 2 | 5 | 3.75 | 2 | 4 |
Any help would be appreciated.
