I have DMR cross tab report where Company is both dimension and hierarchy and crosstab node member is made as Summary(Company).
Problem is from Tree prompt when user selects only United States totals comes correct but when user selects Company(All) and also selects united states
Crosstab node member sums up both Company and United states.
Expected result is when user selects Company(All) and also selects united states
Crosstab node member should show only Company and not United states.
Actual result what is happening in report is when user selects Company(All) and also selects united states
Crosstab node member shows addition of Company and United states which is wrong
I have tried various classes of crosstab node member like crosstab fact cell (subtotal more+hidden) then crosstab member cell(subtotal excluded)
but nothing shows correct group totals
can any one suggest what can be done
SOLVED
Used prompt many to default Company(ALL) when user selects Company(ALL) and United states and instead of Crosstab Totals from tool used data item
1)For company promt wrote
set ( #promptmany ('p_Location', 'memberuniquename', '[Hierarchical].[Company].[Location].[Company (All)]->[all]')#)
2)Pulled [Company (All)] level from model to Query Item
3)Wrote data item with below expression
aggregate(currentMeasure within set [Company (All)])