4 Replies Latest reply: Sep 9, 2014 2:53 AM by Jonathan Dienst RSS

    Concat dates with condition

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

      Good day!

      In attached model i calculate in one pivot table sum(quantity by Spoints), in second - concat dates where sum(quantity)>30

      But result is wrong.

      Expected result:

      Spoint1: 23-09-2014, 25-09-2014

      Spoint2: 22-09-2014, 23-09-2014, 24-09-2014, 25-09-2014

       

      Thanks!