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