0 Replies Latest reply: Apr 23, 2012 1:51 PM by Justin Martin RSS

    Custom trendline using set expression

      Hi,

       

      I have a chart that shows YTD actuals by month (so now you'd see 4 columns, Jan to April) and I'd like to show a trendline for average full-year forecast, which would involve a set expression like sum({$<Scenario = {'Forecast'}, Year = {$(CurrentYear)}, Month = {12}>} YTDCOST).  I can't seem to get it to display correctly, maybe because it references a completely different set of data than the Actuals bars.  Any help would be appreciated (doesn't have to be represented exactly this way, just want average FY forecast and YTD actuals by month on the same chart somehow).

       

      Thanks

      Justin