I am trying to get the median for a number of cells. Has anyone resolved
this issue as described.

Jan Feb Mar Qtr 1

A 10 5 E 15
B E 4 3 7
C 0 2 1 3
A+B+C 10 11 4 25

Median 10/1 11/3 8/3 25/7

Points to note:
E - Stands for empty cell
0 - A cell as zero in but we do not want this counted as cell point. How do
we eliminate this cell point?

We have tried the code below but seem to be missing something. Any ideas
from anyone?

Median(CrossJoin({Descendants([Month].[1].CurrentMember,,LEAVES)},{Descendan
ts([Product].[1].CurrentMember,,LEAVES)}))