1.ods (21.6 KB)
Having again this situation, how can i calculate on the C and D columns the sum for every 7 days and the sum for the last 7 days? I am looking for a formula that goes for the whole column, not just one cell.
Thank you.
Create a Pivottable ( ⇒Data⇒Pivottable…)
select one Date in the pivot-output, and ( ⇒ Data ⇒ Group and outline ⇒ Group ) by 7 days
seven_days_pivot.ods (17.5 KB)
1 Like
@karolus
What about the last seven days? That would mean that from the seventh of march i get a number every day. How do i do that?
Go to ( ⇒ Data ⇒ Group and outline ⇒ Group ) switch Start to [x]Auto and End to any date which comes to your mind