are you looking to calculate running median ?
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
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:
could you attach your workbook
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.
Emailed it to you.
let me look into