Group by measure
I need group a measure by another measure in 11g Analysis. For instance, Customer_CNT and Order_CNT are both measures. I want to know how many customers put one order, how many customers put two, etc. I tried while...case statement. It didn't work. Any way to do that?
Thanks.