9 Replies Latest reply on Jan 9, 2018 6:26 PM by parul bansal

# Rolling median - income over months

This is where I am right now:

Since the cycle starts from Oct, the months are placed in this sequence. Right now the graph tells me median for income corresponding to data of that particular month only.

Goal - To get median of income for data of current month and all months prior to it, in sequence as mentioned above.

I did go through some discussions, suggesting offsets and window_median.. but am unable to wrap my head around it for this solution. Any help/suggestion will be really appreciated. Thanks!

• ###### 1. Re: Rolling median - income over months

are you looking to calculate running median ?

• ###### 2. Re: Rolling median - income over months

Yes, Parul.

• ###### 3. Re: Rolling median - income over months

well I dont have your work book to edit. So, please follow below steps  on Median Measure in row section

1. right click - Edit Table Calculation

2. Select Moving Calculation as a Calculation Type

3. Summarize values using: Sum

4, Moving along by date(your dimension field)

Please find snapshot to show you moving sum of profit & profit vs Month.

Note: create medianIncome measure

and Table calculation snapshot

let me know if you are looking for this

• ###### 4. Re: Rolling median - income over months

Thank you for your response, Parul.

When I follow the approach, I am reaching the same result as - right-clicking on the median measure -> quick table calculation -> running total.

Which is, i guess, summing the median value for each month? Whereas, I want median of all data points together.

I chose 11 in the 'Previous values' field in Table Calculation window, because I want the last month to include data of all previous months.

Here is where I am now after follow instructions:

• ###### 6. Re: Rolling median - income over months

I am unable to upload the file here somehow... can I email it to you?

I won't be able to share the exact workbook, however, here is a dummy of relevant fields and how the sheet is setup.

This should be enough for you to stroll and explore through.

• ###### 7. Re: Rolling median - income over months

send to parul_bansal10@yahoo.com

• ###### 8. Re: Rolling median - income over months

Emailed it to you.

• ###### 9. Re: Rolling median - income over months

let me look into