5 Replies Latest reply: Aug 20, 2014 5:01 PM by Alex Byrd RSS

    Sum of values, where value=1

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

      Good day!

      In attached model in pivot table TASK calculate count of Date, where quantity>0. And now i want to calculate sum of "1" (where quantity>0) by Spoint

      But i need to do this not by deleting of DATE dimension or using in toolbox option TOTAL.

      I need to do this by expression.

       

       

      Best regards