Hi Steve,
the issue is to do with an IF statement i have put into the expression..
this is as follows:
i have 3 categories for VersionSelect, they are Budget Forecast and Last_Year.
When i select either Budget or Forecast, the first part of the IF formula works and the graph maps out the data by period for all periods.
when i select Last_Year,this should get the second part of the IF statement to work, but it only shows data for one of the periods and not all the periods even though i've put Period = {"*"} into the set analysis.
i woudl be very grateful for any other suggestions!
many thanks
=if(VersionSelect <> 'Last_Year',
Sum({$<Input_Sheet = {"DM"},
Obj_# = {"*"},
KPI = {"Total print net advertising revenue (£m)"},
KPI_Definition = {"*"},
Owner = {"*"},
BU = {"DM"},
Level = {"*"},
Data_Contact = {"*"},
Data_Source = {"*"},
Period = {"*"},
YTD = {"YTD"},
CurPd = {"*"}>} $(vComp_Version)),
Sum({$<Input_Sheet = {"DM"},
Obj_# = {"*"},
KPI = {"Total print net advertising revenue (£m)"},
KPI_Definition = {"*"},
Owner = {"*"},
BU = {"DM"},
Level = {"*"},
Data_Contact = {"*"},
Data_Source = {"*"},
Year = {$(#=Year-1)},
Period = {"*"},
YTD = {"YTD"},
CurPd = {"*"}>} Actual))
/
sum({$<Period = {"*"} ,
YTD = {"YTD"},
CurPd = {"*"}>} SumWeeks)
