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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,114,019
Messages
5,545,523
Members
410,689
Latest member
ConfuzzledThomas
Top