3 Replies Latest reply: Jul 23, 2014 9:42 AM by Александр Закревский RSS

    actual sales date

    Андрей Шепель

      Good day!

      I have some problem with calculation actual date for different values of dimension

       

      I have pivot table with dimensions : Product and Sales point

      in expression i show sales for the last actual date

       

      But i want to show  sales with actual date for such sales points, which have sales > 0 at least for one product.

      In my example i show last actual date 22.07.2014, but for Sales point 2, Sales point 8 and Sales point 9 i must show sales other last date, which has sales > 0 at least for one product

       

      Thanks for all advices!