Set Analysis Help

[Anonymous]

Hi All,

    I am having following two tables of Master Calendar and Application Table.

    But I need to create a chart which should have the date as Dimension from Master Calendar date,that should equal to Application Date Value.

To make clearly I need to have a condition like Where MasterCalendar.Date=ApplicationDate

Kindly let me know

-Jay

[Anonymous]

Hi Giacomo,

   Due to my data Model, I cant rename and link with Master Calendar. If I rename, I will get circular reference. That's why I am keeping separately.

[giacomom]

Okay I see,

I tried with a simple example here: the calendar object uses the Master Calendar date field "Ref_Date", and the chart expression is =Sum({$ <Date=Ref_Date>} Amount).

The only thing is that you have to select at least one date to make the chart display a result.

Otherwise you can solve this by modifying the expression like =Sum({$ <Date=P(Ref_Date)>} Amount)

to get the results even when you don't select any date from your Master Calendar.

I hope this helps,

Giacomo