Tuple expression in DMR giving only one Department Sales not all department

[tarunkrdas2013]

Hi ,

I need Daily sales  and Week to Date sales values for each departments but my expression gives value for only 1 department.Here is my Tuple expression ,can some one suggest

tuple ([Hierarchical].[Sales].[CMP Member Net Sales Amount],[Hierarchical].[Fiscal Calendar].[WTD_AS_OF_YESTERDAY].[WTD_AS_OF_YESTERDAY(All)]->[all])

[tarunkrdas2013]

I am trying to achieve

Dept    Daily               Inc        WTD               Inc
11       130.9100       26.67%  633.8800    -10.68%
12       35391.1600  -4.44%  273991.3200 4.64%
13       67612.8600  -8.62%  533159.7800 5.61%

[tarunkrdas2013]

Its DMR i know its not good practice to use detail filter but we have used below:-

roleValue('_businessKey',[Hierarchical].[Company].[Location].[Location] ) = #prompt('pmt_Location','string','110')#

can some one suggest how to i achieve my requirement

[bdbits]

Why are you bothering with tuple expressions at all? Assuming your facts and your time dimension have the granularity required, I am not seeing anything that is not achievable with regular drag-and-drop operations into a crosstab and some dimensional aggregation functions. Or am I missing something?

[tarunkrdas2013]

Its a List report and Expressions for fields in the report i used are:-

Dept
substring ([Hierarchical].[Department].[Department].[Department].[Dept Num],1,2)

Daily Sales
tuple([Hierarchical].[Sales].[CMP Member Net Sales Amount],[Hierarchical].[Fiscal Calendar].[Yesterday].[Yesterday(All)]->[all])

WTD Sales
tuple ([Hierarchical].[Sales].[TY Member Net Sales Amount],currentMember ([Hierarchical].[Fiscal Calendar].[WTD_AS_OF_YESTERDAY]))

Inc
tuple ([Hierarchical].[Sales].[CMP Member Net Sales Amount],currentMember ([Hierarchical].[Fiscal Calendar].[WTD_AS_OF_YESTERDAY]))