I need to show cumulative sales for certain product type.I wrote following expression it is giving error:
Running-total ([Order Item Details].[Order Item Details].[Net Sale Item Qty] for (case when [Order Item Details].[Application].[Platform Name] =‘ABC’ then
[Order Item Details].[Order Item Details].[Net Sale Item Qty]
else
null)
end
)
and if i need to show monthly,quaterly,yearly cumulative sales separately,how this case statement should be written
Appreciate your help