Forum Discussion
Pivot table - Median - transposition of column
Hi, I have a pivot table which contains rows Destinations (countries). Every country has number of different Rates (in currency). Rates are also in rows (because otherwise - if i put it into values -...
If you only need median or other aggregations you may add measures to pivot table and show them without rates. If you need both perhaps it'll be better to transform your source data with Power Query.