Dynamic Period over Period Comparison in a Pivot Table ?
I'm trying to compare the sales for the months selected and the same months for the previous year and add a sales variance percentage as a new column at the end. When I tried to do its, the variance is repeating for each month. I only want to display the sales variance between current month & current month of last year at the very end of the pivot table. How to do it in Qlikview ? I have attached a sample spreadsheet of the layout.
Did the posters last reply help you get what you needed working? If so, please be sure to give them credit by clicking the Accept as Solution button on the post. If you are still struggling with things, please provide an update, or if you used a different solution, you can post that and mark it as the accepted solution as well to give any future readers more ideas.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.