Feb 21 2022 06:09 PM
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?
Currently, my pivot table only shows average values.
If pivot table is not possible, it would be great if you could show me how to use XLOOKUP function or another function and kindly explain the rationale.
Thank you,
Amy
Feb 21 2022 09:53 PM
Solution@AmyYang See attached. Have used UNIQUE and FILTER to achieve what you asked for. See the green shaded area in the attached file.
Feb 21 2022 10:11 PM
Feb 22 2022 05:29 PM
@Riny_van_Eekelen Hi Riny, that is amazing idea, thanks so much!
Feb 22 2022 05:30 PM
Feb 21 2022 09:53 PM
Solution@AmyYang See attached. Have used UNIQUE and FILTER to achieve what you asked for. See the green shaded area in the attached file.