Forum Discussion
Solved
How to create pivot table with median values?
Hi, I am seeking to make a pivot table that shows the different median values for different countries from a list of table. Could someone show me how to create pivot table with median values...
AmyYang See attached. Have used UNIQUE and FILTER to achieve what you asked for. See the green shaded area in the attached file.
AmyYang See attached. Have used UNIQUE and FILTER to achieve what you asked for. See the green shaded area in the attached file.
Riny_van_Eekelen Hi Riny, that is amazing idea, thanks so much!