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?
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
AmyYang See attached. Have used UNIQUE and FILTER to achieve what you asked for. See the green shaded area in the attached file.
4 Replies
- Hi Detlef, wow, a pivot table was really created with median values!! Thank you! I will search on how to use Power Query + DAX measure to recreate this for my other files too. Thank you so much!
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!
