Calculate sum for different range

[Sir_Johanos]

Hello. Please help me world.

I have data set for example

[ N, date_r, Sum

1, 09.11.2019,5

1, 10.11.2019, 10

1, 11.11.2019, 20

2, 10.11.2019,30

2, 09.11.2019, 40

]

I whant calculate sum of last 2 days for all N. But max date for N=1 is 11.11.2019 and for N=2 is 10.11.2019

So I need table like this

1 30

2 70

Bu I cant use formula like this Sum({<date_r={'<=$(=max(date_r))>=$(=date(max(date_r)-1),'DD.MM.YYYY'))'}>})

in result I will take

1 30

2 30

because set analyser calculate max(date_r) for all chart 11.11.2019.

So,How I can solve It?

Thanks

[Sir_Johanos]

up.

please . need help ! 😞