Forum Discussion
Calculate median in excel pivot table
Hi all, I am trying to insert a median column next to grand total in the below pivot table. I don't want the median count of specialist role, I want the median Day Rate (from extracted price or p...
Better if creating the PivotTable you check the option to add data to data model and add measure to PivotTable using DAX MEDIAN() function https://docs.microsoft.com/en-us/dax/median-function-dax
Adding the measure right click on table name in right PivotTable pane and add formula into the form.