In a pivot table i want the yearly totals of all columns. However when i use partial sum qlikview summarizes all years of a product.
The Product and the Year are dimensions
I need the final report to be like the one below. Can you please help me. (The expressions have sums from a table via sql query)
| PRODUCT | A | PRODUCT | B | TOTAL SUM OF ALL | PRODUCTS |
| 2017 | 2018 | 2017 | 2018 | 2017 | 2018 |
| EXPRESSION A | 1 | 4 | 3 | 7 | 4 | 8 |
| EXPRESSION B | 2 | 5 | 5 | 3 | 7 | 12 |
| EXPRESSION C | 3 | 2 | 7 | 5 | 10 | 12 |
| EXPRESSION D | 4 | 6 | 3 | 5 | 7 | 13 |
| EXPRESSION E | 4 | 5 | 1 | 4 | 5 | 10 |
