Forum Discussion

p_kaushal's avatar
p_kaushal
Frequent Visitor
9 years ago

How to keep total base constant from the data table

Hi I have a table with the below columns Yearweeknumber (e.g. 201701) Day text (Mon,Tues, Wed, Thurs) Region Store format Channel Competitor store Product Sales TY Sales LY   I need to cal...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

But,the issue arises when I try to get the same as I have a relationship between this table and another which is at 'PSG' level.The relationship between them is at psg level.If I take any other column from the other table to visualize my data my LFL contribution is incorrect as that column name is not in the ALL expression.

 

How do I make this ALL in the denominator include anything else from other tables too?

 

Hi p_kaushal,

 

Can you share some sample data of 'all store data by day' table and the other table which has relationship use 'PSG'?

 

Best Regards,
Qiuyun Yu

p_kaushal's avatar
p_kaushal
Frequent Visitor
9 years ago

Hi v-qiuyu-msft,

 

I have uploaded sample data here.  The first tab has the 'all store data by day ' I have mentioned and the second has 'PSG' level data.

 

When I use the above formula as mentioned in the first table it works fine.But when I take 'Junior Buyer' from the second table the %contribution numbers goes for a toss.The relationship between these two tables is on 'PSG'