Hi,

I have the following data:

Qty
---
2005, Jan | 100
2005, Feb | 110
2005, Mar | 120
2005, Apr | 100
2005, May | 90

and I'd like a MDX query returning the most frequent value of measure
Qty, 100 here. I have found a really ugly way (involving a new
dimension!) but I'm not really proud of it and, more important, it's
quite slow !! Any help ?

It looks like you're asking for the mode. Unfortunately, there's no Mode
function in native MDX. Another problem you're faced with what to do when
your set has more than one mode, which is possible. What's your criteria for
breaking the tie? With an answer to this, it might be easier to find a way
to approach this.

- Phil

"Ethan" wrote: