3 Replies Latest reply on Jan 8, 2018 3:44 PM by Cecilia Saldaña

    Previous Year Sales

    Cecilia Saldaña

      Hello,

       

      I am looking for a way to calculate previous year expenses "calculations" based on a selected Year Filter (Year Filter has been defined as Lookup in order not to loose other years information when only selecting one year.

                                                                                       

      New VehiclesUsed Vehicles
      Expense TypeExpenseDif vs last yearExpenseDif vs last year
      Fixed expenses120,000-20089,000+450
      Variable expenses90,000+1,30050,000-300
      Other expenses97,000+1,45056,000-560

       

      There is a YEAR Filter so we can select what year to see in our report (only one year at the time).

      But I do need to estimate previous years expenses, in order to have the difference between the Selected year and the previous one.

       

      My main problem so far is to display last years data when filtering one year,, because it will not display (due to the filter)... I have been using Lookup function...

       

      Thank you,