How can I calcualte the sales value from 1/15/2005 to 4/23/2005 Using Sales Cube?
Use calculated member with a sum function. The set in the sum function should be specified as time range between members of Time (or Date). You can easily do the range as "member1 : member2", like in this example:
select [Date].[Date].&[1] : [Date].[Date].&[271] on 0 from [Adventure Works]
No comments:
Post a Comment