Hi, QV community
I would be grateful if someone could help me with the following issue.
I set a simple dataset with dummy data.
I need to calculate the percentual difference between hist.sales and forecast
In the pivot chart, I added a calculated dimension =(fcst-hist)/hist
I works fine for lines, but I need to make the same operation with totals (as Excel pivot charts automatically do!!!)
In short, I need QlikView to calculate and show the value in yellow
(sum(fcst)-sum(sales))/sum(sales)
Thank you in advance!
base data
| article | Hist.sales | Forecast | % increase |
| item 1 | 15 | 18 | 20,00% |
| item 2 | 17 | 22 | 29,41% |
| item 3 | 19 | 27 | 42,11% |
intended report
| Etiquetas de fila | Hist.sales | Forecast | % increase |
| item 1 | 15 | 18 | 20,00% |
| item 2 | 17 | 22 | 29,41% |
| item 3 | 19 | 27 | 42,11% |
| Total general | 51 | 67 | 31,37% |
