3Month loss...

[kavita25]

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

[vinieme12]

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.

[kavita25]

It's showing me blank values, if i dont select any month...

[vinieme12]

Set default values to the variables

[kavita25]

What i should keep as default...for dynamic calculation of months...??

And when i am selecting any month...the value chnges..