Rolling 6 Month wise All New Dealer Volume and Throughput

[anikkumarhole]

KPI’s: 

1) Cumulative Rolling 6 Month wise All New Dealer Volume

2) Cumulative Rolling 6 Month wise All New Dealer Throughput

Logic:

Dimension: Month

Measure: Month wise all new Dealer count, Volume and Throughput.

For Volume and Throughput: rolling 6 Month as below Required O/P

Eg. 1) Cumulative Rolling Volume month wise

Jun=Month wise New Dealer Volume of Jun + (Jun volume =who New dealer exist in May);

Jul=Month wise New Dealer Volume of Jul+ (Jul volume =who new dealer exist in May) + (Jul volume =who new dealer exist in Jun)

, etc.

2) Cumulative Rolling Count month wise

Jun=Month wise New Dealer Count of Jun + (Jun count =who new dealer exist in May);

Jul=Month wise New Dealer Count of Jul+ (Jul Count =who new dealer exist in May) + (Jul Count =who dealer exist in Jun)

, etc.

3) Cumulative Rolling Throughput month wise

Throughput =(Cumulative Rolling Volume/cumulative Rolling Throughput )*1000

[sunny_talwar]

Is this based on the same input you provided me above?

[anikkumarhole]

Yes

[anikkumarhole]

Yes Dear

where we can get June=June total volume +( exist(May and June  DMS Outlet code) June volume)

similarly July=July total volume +( exist(May and July DMS Outlet code) July volume) + ( exist(June and July DMS Outlet code) July volume)

[sunny_talwar]

I will play around with this to see if I can understand this...

[anikkumarhole]

Can you please resend it.

Thanks & Regards,

Anik Hole

[sunny_talwar]

Resend what?

[anikkumarhole]

Hi Sunny Can you please let me know how we can get matching value from (June and May), (July and May, July and June) as per above  provided sample data ,