Hi,
i'm working on sales report based on DMR.
currently I've created
sales by category, day
category: [Category].[Category1].children[All]
day : [Period].[Day].children[All]
StartRange/EndRange : MUN
I filtered the day with the date range using MUN in detail filters as below.
[children(All)] between [StartRange] and [EndRange]
what i try to get is row total for each category.
I've tried to just use automatic summary or total for crosstab.
but, it shows - values for the report.
category Sun, 01 Feb 2015 Mon, 02 Feb 2015 Total
1 $1,524.82 $4,665.91 -
2 $1,302.60 $2,081.42 -
3 $315.91 $2,320.83 -
i've been trying to use total function total([Value1] for [children(All)]) but,
it comes with the error
The FOR clause of 'total' must reflect the left to right order of query items up to and including the item that specifies the control break for the function.
- any suggestion for getting row totals in filtered children set for day?
- any workaround for filtering date range?
thanks in advance.