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]

You need to make a selection in the Month Field! otherwise the variables won't evaluate

[kavita25]

even if i do selection, its showing me wrong count...as some dealers should not come...but they are considered.

9110015100041,9110012201322 should not be considered...

[kavita25]

stalwar1‌ gwassenaar‌ swuehl‌

Please suggest me some idea..to solve this issue.

[vinieme12]

these don't come!! what are you selecting?

9110015100041,9110012201322

[kavita25]

I am selecting the same month and code...

It's showing me Aug in bar chart...

[kavita25]

Hi stalwar1‌

I want those Outlet code where its next 3 month has no sale...but the particular month has sale..

9110012202628 this code should come under Nov Month-- Coz it has sale in the month of Nov but not in Dec Jan Feb...

Hope so now ur clear with my requirement...

How to show repeat purchase..  In this post... I wanted particular month and next 3 month should have sale..

Now this requirement is opposite of it..

Can u Please suggest me some ideas...

Regards,

Kavita

[kavita25]

Hi,

Please help me with this issue or suggest me some ideas to resolve this.

stalwar1‌  

vinieme12‌

swuehl‌

gwassenaar‌

Regards,

Kavita

[kavita25]

Can anyone please help me with this issue...

vinieme12‌

swuehl‌

stalwar1‌

[vinieme12]

Can you post post th app that you are using so I can Make corrections to the same

[kavita25]

Yes..

PFA...