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
