How to have a calculated Member that is independent of my slicer

[cognos05]

Hi,

I have a report showing daily Sales and at the end of the column I need to add an MTD .

Days - > Day -> 1,2, etc... so [Day] would give me MTD.

Rows Regions and Column Products and at last MTD.

I am trying to use a complete tuple( currentMember(Regions),[Days],[Displayed Producton Columns] ,[Full Revenue])

But my MTD value is always pointing to the products root member .and Days is filtered with current day, its not pointing to [Days] Member.

Is there any other approach to achieve this. I have attached the screenshot for the issue.

Thanks,
Nithya

[BigChris]

I've read that a couple of times and I'm still not sure what you're trying to achieve...my failing, not yours :)

In the first row of your screenshot you've got 3 totals:
Total PD = $1,108,296
Total = $1,353,748
MTD = $1,362,287

Which one of those is correct? In one row the Total = MTD (region E?)...is that down to the filters you mentioned?

[cognos05]

Siicer for the report has filter on day [2] - last member from day dimension.so the report is going to filter for 2nd feb.
But I want my MTD column to still show the sum of day 1 and day 2 .

SO the last column in the report MTD  uses the expression  complete tuple( currentMember(Regions),[Days],[all products displayed on column] ,[Full Revenue],[Days])
but the issue here that number is not considering all the days , its only considering the slicer day value eventhough I have given the root member in complete tuple.

MTD = 1362287 is wrong

And other Total = 1353,748 is correct , ignore the total PD.

[MFGF]

complete tuple( currentMember(Regions),[Days],[all products displayed on column] ,[Full Revenue],[Days

complete tuple should be all one word in your expression - completeTuple

MF.