Hi, i am new to MDX query could anyone help me in determining cummulative revenue...i have written that in SQL but i need the same in MDX form...
idRevenue Cummulative Revenue
12020
23050
31060
440100
520120
Select a.id,
last(revenue),
sum(revenue) as cummRev
from
order a
inner join
order b
on
a.id >= b.id
where
a.id < 5
group by
a.id