Aggregation of line items for account

      Aggregation of line items for account

      Hello everyone,

      I haven't found a thread so far covering this subject and haven't really found a solution in the knowledge base either.

      Say I have a only a file of line items (i.e. seperate entries to the account) to all P&L accounts and want to get the aggregation done via integrator.
      How would I achieve this, since the aggregation function in the field transform aggregates accross columns but not accross lines, or am I just too blind to see it?

      And I cannot use the "add" in cube load, just the "insert", because the provided files always contains all periods of the year. And they should always be overwritten.

      Let's assume the data looks something like this:
      Period
      Account
      Cost center
      #Value
      11.2017
      43200000
      10004000
      -2000
      11.2017
      43200000
      10004000
      -500
      11.2017
      43200000
      10005000
      -60
      11.2017
      43200000
      10005000
      -40
      11.2017
      43400005
      10004000
      -1000
      11.2017
      43400005
      10005000
      -100


      the intended result that should be written to the cube would be this:
      Period
      Account
      Cost center
      #Value
      11.2017
      43200000
      10004000
      -2500
      11.2017
      43200000
      10005000
      -100
      11.2017
      43400005
      10004000
      -1000
      11.2017
      43400005
      10005000
      -100

      IMORTANT: Should be still applicable to Jedox 6.0 SR3

      Thanks a lot in advance for any hints and help.

      BR
      Bjoern