Multiple dates using only 1 master calendar

[kiranpatil123]

Hi guys , please help on this task .

I have 2 tables say table 1 and 2 .Using ONLY 1 MASTER CALENDAR [ which includes both the dates (Date-1 and Date-2) ]

and also consider table- 1 as MASTER and Table-2 as TRANSACTION   .

I need the following scenarios

1) Based on S.no and Date-1  from [Table 1]  I need values from [Table 2]

2) Based on Date-1 from [Table1 ]  I need values from same table [Table 1]

3)  Based on Date-2 from [Table 2 ]  I need values from same table [Table 2]

. and I have attached the following files in order to solve the problem .

[sasikanth]

i might not correctly understand your requirement but try below exp

Try this,

1) =Sum({<[Date-1]=p([Date-2])>}Values)

2)=sum(value) (based on same table -1)

3) =sum(values) (based on same table -2)

[ajsjoshua]

Hi Kiran,

Try this

Canonical Date

Regards,

Joshua.

[ajsjoshua]

Hi,

PFA

[kiranpatil123]

thanks you Joshua , but iam looking to use only 1 master calendar not multiple .