Create a for loop to sort the months and get the middle/median value (URGENT)

[sandp707]

Hello everyone,

Could someone please help with a script as this is very urgent.

I want to create a for loop to sort on basis of 3 Months and get the middle values from measure.

Data granularity - Under market there are products, and we can same product name under multiple markets

Column E - 

This is the sample data screenshot, here I want to create a for loop with a counter which will sort the Count (column D) for every 3 months (column A) and bring the middle/median of the Count column and place it in Column E (highlighted).

Column F - 

This column is difference between the median derived from above for loop and the current month 

Column G - 

This is again the median from Column F (difference) and this should also be from a for loop.

I want this using for loop as because the number of months to derive the median can be 3,4,5... as per the client request.

Thanks,

Sandeep

[MarcoWedel]

are you looking for a script solution or a chart expression?

[sandp707]

Hello Marco,

I am trying to achieve from script. If you can help with chart expressions is also great. 

Thank you

[sandp707]

Hello everyone,

I need to see the median of the previous 3 records. 

 Where, prev 3dlvry = median of previous 3 records 

actual deviation = difference between current count and the median of prev 3dlvry

typical deviation = total median of actual deviation