6 Replies Latest reply on Oct 2, 2018 8:20 PM by Alysse Mea

    forecast vs actual

    Alysse Mea

      I need help with showing the monthly forecast as reference line but I can't make it work. My forecast values are hard coded as they are not available yet in my sql data. I have simplified my data in the attached workbook. Basically, what I want to do is to be able to select the month and then only show the forecast for that selected month. If ALL is included, then sum of the forecast for all months will be displayed as the reference line. My forecast numbers are not broken down by location. Snapshot below:

      When ALL is selected, my forecast reference line value must be 534,871 and when Month 1 is selected, value must be 15,200. Appreciate any help.