Need help to create this view in Qlik Sense Pivot table. Sample data is attached in the excel
| | Prior Months | Current Month | YTD | YoY% |
| | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Budget | Variance | Sep-17 | Sep-Budget | Variance | Sep-16 | Sep-16 v Sep-17 | YTD 16 v YTD 17 |
| Con | 10 | 40 | 50 | 90 | 110 | -20 | 200 | 210 | -10 | 540 | -45% | -63% |
| Churn | 5 | 20 | 25 | 45 | 55 | -10 | 70 | 155 | -85 | 270 | -21% | -74% |
| Upgrd | 6 | 24 | 30 | 54 | 66 | -12 | 90 | 166 | -76 | 324 | -27% | -72% |
This seems similar in approach to solution mentioned in below blog. However I am new to QlikSense and not able to adjust this to my requirement.
Qliksense: Need YTD column in pivot table
stalwar1
