4 Replies Latest reply: May 21, 2014 4:44 AM by Marcin Szaleniec RSS

    Sum if values last year more then 0

      Hello,

       

      Could anybody help me with one problem?

      I neet to build a pivot table where one of expressions is sum of sales. But I would like to sum up sales in only those units which reported any sales in the corresponding period of the last year. Simply, I would like to sum up sales of stores that worked/existed last year. Should I use set analysis (how) or some fancy 'if' formula?

       

      Thanks in advance,

       

      Marcin