Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to show volume loss for dealers..i.e If the dealer is billed in May and no sale in next 3 months i.e Jun,Jul, Aug.
So for that dealer is loss for the month of May.
In simple words if May is >0 and Jun,Jul,Aug sale is <0 then it is loss for that month..
Similarly I have to show for Jun and next 3 months, Jul..and so on...
My dimension is Month field..
swuehl - You helped me to get next 3 months bill..How to show repeat purchase.. in this post..
Kindly suggest me to solve this issue...where the next 3 months is in loss..
Regards,
Kavita
Check the attached,
I would suggest using YearMonth field like 201601,201602.....for such calculation so you can evaluate over different months from Dec 2016 to Jan - Mar 2017.
It's showing me blank values, if i dont select any month...
Set default values to the variables
What i should keep as default...for dynamic calculation of months...??
And when i am selecting any month...the value chnges..