Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,to
I'm trying to make a pivot table with total sums of sales in previous month; the goal is to get something like this:
Year Month_Name Sales in Previous Month Sales in This Month
2013 October 0.00 669,425.25
2013 November 669,425.25 632,081.48
2013 December 632,081.48 1,050,705.58
I've tried a solution found on iQlik (please see my attachment) but it doesn't work. Can anybody fix it and / or explain?
Thanks in advance!
Regards,
Pawel
Hi Pawel,
I have done this . u can check the qvw file in which both current month and previous month wise sales is working .
If u select the year then it will show the current month and previous month sales of selected year according to the product code.
Dear Dhiraj,
Thank you very much and I really appreciate your help. It don't seem to work when I add month name to dimensions - can you tell me why?
Hi Pawel,
The month_name would be work as dimention when u will use the bar chart. Bcz when u will pass the month_name as a dimension in pivot table then it will show only that month sales which is in dimension .
According to that month which is in dimension the sales would be appear if we will calculate the previous month then it will show the zero bcz it will not get the dimension.