I try to calculate the median with the suggestions made by one of your blogposts. https://help.zoho.com/portal/en/community/topic/how-to-get-median-to-work.

I use a pivot chart in which I have the number of patients that had a fall per month listed. I added the formula as suggested by the answer to calculate the median: Percentile("Autoview_1498650252695_Clinical_Quality_indicato Table"."Number of patients that had a fall",50) but that does not work. 

Can you provide me with some suggestions to make this work? I try to incorporate the custom formula option but could not find a workable option.

Regards

Jan Weststrate