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