Median Absolute Variance Power Pivot table

BoVas

New Member
Joined
Sep 9, 2020
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
  2. MacOS
Hello,

I'm creating a dashboard that keeps track of the Coefficient of dispersion. For this, I created a column that calculates the absolute variance from the median. I'm using a Medianx(sales,[ratio]) however this calculates the ABS Variance using the median of all the data. I would like for excel to use whatever median is being filter through the pivot.

Thank you in advance for your help!
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,118,415
Messages
5,571,973
Members
412,430
Latest member
Huuktkt
Top