Hello my outpushould be like the following:

Frequency Report

last3months 3 months 3 months

number of sales only once 2-4 times 5-9 times

Customers(names) 900 300 75


Time,customer are the dim's. .so how to get ouput from
sales cube(using mdx)...

The following qry is working for last 30 days totoal
counts for sales..(here store count is the measure on
product id column set aggr function as count in the cube)
member [Measures].[Last30Days] as
'sum(tail(filter([Newtm].[The Date].members, ([Measures].
[storecount] <>null)), 30), [Measures].[storecount])'
so how can i get the abv output..can u gv
suggesitions??