Calculating measures based on dimension not present in crosstab

[morpheus]

Hi All,

I have a DMR model which contains Product, Time and Customer as Regular dimensions and "Number of distinct Orders " as a measure dimension.

My first requirement is ,
To have a drill-able cross-tab containing products in the row edge and Time in column edge. The fact cells should contain number of customers who gave more than 1 distinct orders for the product and time scope. This requirement has been achieved using a filter member set and doing a Count(1 within set) technique.

My second requirement is,

Cross-tab edges same as above, but there are 3 sets of facts.
1> Number of customers having placed order 1 time
2> Number of customers having placed order 2 or 3 times.
3> Number of customers having placed order > 3 times.

I am trying to use the same technique , but not working for me. Could someone shed some light on this. Do I have to use any other technique for this one..maybe tuple calculations??