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
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?
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.
Quote from: nithya1224 on 03 Feb 2016 09:01:07 AM
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.