calculate median on pivot table with data from multiple columns

I have the following data:

I want to know the median for days from submission to PRD based on request types and the year. For example, the median for days from submission to PRD for the edit (and other types) in years 2016,2017,2018,2019, and so on in a pivot table.

However, it seems pivot table does not have the median function. I was wondering if there is any workaround for this.

so far, I was able to come up with this formula:

{=MEDIAN(IF($D$2:$D$3650=D2,IF($B$2:$B$3650=B2,$E$2:$E$3650)))}

but, it does not give me correct value. For example, I want media for the "EDIT" request type in year 2016, or median for amendment for year 2019, or median for all request types for all years.

Thank you for your time.
xx.png

1. What, exactly, do you mean by: " it does not give me correct value"?

2.You have attached an image. That's not very easy to work with. Also... I'm lazy. I have to re-type your information before I can begin to address your problem. That puts me off completely.

So.

Do yourself a favour and please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough). PLEASE SHOW some manually calculated expected results. Also, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever).

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Make sure confidential info is removed first!!!!