Item not referenced in Layout,add it to properties

[dech008]

Hi,

Using a chart which shows whole year data for selected Year(value prompt) and selected Month for a particular account in series.

what I am trying is to add conditional palette based on the selected month(value prompt).
if selected month is Mar -> all month colors will be Blue including Mar.
and color would be red prior to Mar.

Conditional palette->advance->String Condition
(Data item_selected month > Data item_complete year data)

Data item_selected month = Construction MUN using selected year and month
Data item_complete year data= LastPeriod(12,Constructing Dec month using selected Year)

Now the problem is when i try to validate the conditional palette it says ->Item not referenced in Layout,add it to properties
so i ticked the item in properties in which is not referenced in Layout.
Now it ask me to give the master- detail relationship (Master detail relationship is missing from crosstab or chart).
I am using chart only.

Can anyone has any idea...how to resolve this.

Thanks,
Deb