8 Replies Latest reply: Aug 19, 2014 4:04 AM by Simen Kind Gulbrandsen RSS

    Count dates with condition

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

      Good day!

      There is pivot table TASK in attached model with quantity by Spoints and Dates.

      My task is to calculate count of dates by Spoints, which have quantity>60 % from avg(sum( total <Spoint> Quantity))

       

       

       

       

      Thank you!