Last 6 month no sale but with the min Date

[kavita25]

Hi,

I want those count whose sale last 6 month has no sale..but it should show for the min date...

For e.g

Dealer 1 has Sale for Nov and Dec

This dealer should show in the month of Nov and not in Dec...

My dimension is Month..So from Nov it should count for 6 months..not in previous months as my data is from May 2016.

stalwar1‌ gwassenaar‌- Please help me with this issue..

I tried this below logic...but no success...

=Count(

{<[DMS Outlet Code] =

     e({<InvFiscal_Month = {"=InvFiscal_Month=$(=Min(InvFiscal_Month))-1","=InvFiscal_Month=$(=Min(InvFiscal_Month))-2","=InvFiscal_Month=$(=Min(InvFiscal_Month))-3",

     "=InvFiscal_Month=$(=Min(InvFiscal_Month))-4","=InvFiscal_Month=$(=Min(InvFiscal_Month))-5","=InvFiscal_Month=$(=Min(InvFiscal_Month))-6"

     }>})

     *p({<InvFiscal_Month = {"=InvFiscal_Month=$(=Min(FirstYearOfSales))"}>} )

>}

DISTINCT  [DMS Outlet Code])

Regards,

Please help me with this issue...

Kavita

[kavita25]

also tried this logic to get the min date...

Count(DISTINCT If(Aggr(NODISTINCT Min(InvDateNew), [DMS Outlet Code]) = InvDateNew ,  [DMS Outlet Code]))

[sunny_talwar]

May be this:

=Sum(Aggr(If(InvFiscal_Month = Min(TOTAL <[DMS Outlet Code]> InvFiscal_Month), Count(DISTINCT [DMS Outlet Code])), InvFiscal_Month, [DMS Outlet Code]))

[kavita25]

9140013100093-- This dealer code should not come...as its has sale in Oct..

I want those  who has no sale in Last 6 months... like from May to Oct has no sale and its min date is Nov should appear...

Regards,

Kavita

[kavita25]

stalwar1‌ gwassenaar‌ swuehl‌

Please look into this issue...

[swuehl]

Sunny is already looking into, just be a little more patient, please ...

[sunny_talwar]

Not sure but may be this?

[sunny_talwar]

Also, I agree with Stefan on the patience part. We are not here 24x7 (though it might appear that way ). If something is urgent for you doesn't mean it is urgent for all of us. You need to give us time before we can respond just like you take time to respond when you received a response

You took almost 16 and half hours and you expect us to respond in 1-2 hours? All I am asking from you is to be a little considerate of our times also

Best,

Sunny

[kavita25]

Thank You for ur precious time... and sorry for being impatient...

But My Month filter is not working... as i Click on Nov the value change..

In the chart its 826 and after selecting the month it shows 1817...

Thanks & Regards,

Kavita

[sunny_talwar]

Which of the two values are correct? I guess you need to guide us as to what the final numbers need to look like with and without selections.