Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to sort my transaction data by TimeStamp.
However, issues occur when there are more than one transaction at the very same point in time.
QV just ignores sorting these.
Also, I was wondering, when this occurs is it possible to somehow sum these perticular transactions into single amounts for the specific times. For instance:
08:00 100 USD
08:00 100 USD
08:20 200 USD
08:20 200 USD
08:30 300 USD
08:30 300 USD
should be (after sorting):
08:00 200USD
08:20 400USD
08:30 600USD
Any ideas?
Kind REgards,
Olle
Sample file attached.
Running balance should reflect prev running balance+next amount.
Kind Regards,
Olle