7 Replies Latest reply: Jun 22, 2018 10:43 AM by Lucio Gutierrez RSS

    How can i get the year average for the products sold just in the last month?

    Lucio Gutierrez

      Hi Experts

       

      I have a simple table with 3 columns

       

      1- Product

           =Product

      2- Sales average for current month

           =Avg({<Month={$(=max(month))}>}Sales)

      3- Sales average for the year

           =Avg({<Month=>}Sales)

       

      My problem is when I remove the month, I also see products sold in othe months.

      Question:

      How can i get the just the year average for the products sold just in the last month?

       

      (extample Attached

      prouducts without Avg Jun, are from other months, i need removed them from the table).

       

      Thanks in advance

       

      Regards.