1 Reply Latest reply: Apr 14, 2014 5:58 AM by Lidia Vonk RSS

    how to sum multiple rows below - pivot table

      I need to make a table  with the total billed value on YearPeriod x

      this is a start, i need to translate this afterwards in payed days in adition to the costs (work in progress)

       

      DCYearPeriodtotalrow below  WANTEDVALUE
      europeTotal-17.879-
      europe2013012-1.1981.614-17.879C3+E4
      europe20130111.6143.311-16.681C4+E5
      europe20130103.311279-18.296C5+E6
      europe20130092791.457-21.607C6+E7
      europe20130081.4577.752-21.885C7+E8
      europe20130077.752-31.095-23.342C8+E9
      europe2013006-31.0950-31.095C8+E10

       

      how can i create  Wanted Value?