Ask Your Question
0

Sum of amounts by non-sequential date

asked 2017-02-09 20:19:35 +0200

Cantagril gravatar image

I'm sure this probably very simple but I'm tying myself in knots with this...

I have two columns, one is dates and the other amounts. I want to add the amounts by date on a day by day basis with the result in two columns elsewhere - date next to the sum of the amounts for that date, in date order. . The only problem is that the dates in the source table are not sequential so e.g 04/02/17, 05/02/17/, 07/02/17, 04/02/17, 06/02/17, 04/02/17, 06/02/17, 05/02/17 etc etc.

All help gratefully received

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-02-09 21:25:21 +0200

karolus gravatar image

Hallo

→insert→Pivottable -or- →Data→Pivottable→create… (depends on your LO-version )

… drag "Dates" to Rowfield, drag "Amount" to DataField … click ok!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-02-09 20:19:35 +0200

Seen: 24 times

Last updated: Feb 09 '17