3 Replies Latest reply on Jun 1, 2018 6:02 AM by Lauren Brown

    Predicted sales for accounts that do not have a full rolling 12 months

    Lauren Brown

      I have a calculation that was created to show sales 12 months prior to buying a particular item.  Here is the calculation.

       

       

      However, there are several accounts that do not have a full 12 months sales data going forward as they could have just started buying it January of 2018.

       

      My challenge is I need to somehow show predicted sales for the accounts that do not show a full 12 months sales.

       

      Can this be done?

       

      Is it best to use Tableau Analytics? Or build off my current calculation?