2 Replies Latest reply on May 10, 2018 5:16 AM by Ashley Emery

    Forecasting - show running total forecast for a specific date range

    Ashley Emery

      Hey everyone, first post here! Looking for some help with forecasting. I have created a graph of forecast data for the next two years (based on last two years data). I would now like to show the actual and forecast numbers for just a specific date range - for example 01/03/2018-28/02/2019 as a BAN. Whenever I add a filter it obviously breaks the forecasting.

       

      I almost need a way of filtering the data in the view without filtering the forecast.

       

      Any idea how this can be done?