rewriting my original question...
when i don't include the [Dim Date].[Month Number Of Year] on the columns, i get the correct value for Amount which is the amount between the date range in my where clause by days.
when i include it, it returns all of the amounts belonging to the [Month Number Of Year] which may be outside the date range.
how do i write this statement so that i can return the month, but only with the amounts entered within the number of days?
do i need to convert the [Dim Date].[Day] value? if so, how?
-- incorrect results
[Dim Date].[Month Number Of Year].members
[Dim Date].[2007/01/01]:[Dim Date].[2007/01/15]
-- correct results, but displays the days, i want it aggregated by month.
View Complete Post