total MTD of a calculated Member -Dimensional Reporting

[cognos05]

Hi,

I have a crosstab report.  I have a regions level,where I group certain regions using member function like below in rows

member(Total (Tuple([Full Revenue],[Bill Only],[TotalCalculationItems]) within set set([001 - MID WEST],[002 - MID ATLANTIC],[003 - NORTH EAST],[004 - PACIFIC],[005 - SOUTH WEST],[006 - SOUTH EAST],[007 - WEST],[K00 - KIT PACKERS])),'US Regions Bill Only','US Regions Bill Only')

I am calculating the bill only revenue value for certain items for few regions grouped.

In columns I have items and a total of those items and I have a slicer which is todays sales.


so cross tab looks like below
                                                    Product1   Product 2  Total

US Regions Bill Only                     123               123         246

Canada Region Billonly                 450                 450        900


Now I wanted to add a MTD column to the right.

As my cubes have days dimension with days from 1 to 31 its enough if I use the top member for months.

So I create a data item with expression

CompleteTuple([Full Revenue],currentmember([DailySales].[Customers SoldTo].[Customers SoldTo]),[Day],[ItemsTotal])

But the currentMember function has the soldto hierarchy , but in rows those regions are combined in a member function.



so the above expression doesnt give me the expected result.

It gives 0 on the values and I assume since it looks for a sold to member and only finds a calculated member it doesnt know what to do .

Any suggestions on how to get this working.

Thanks,
Nithya