Comparing First and last element of a a 10 days range limited dataset

[marcoserilio]

Hi,

I'm trying to accomplish the following: I've got a dataset made of total market sales per day, I need to get to last day total sales-10 days before total sales, to get to total sales in the last 10 days. Now, I was able to kind of getting to it by using today() function, but my goal to make the report dinamically ever taking into account the last 10 days only, i'd need to use the data field instead.  

sum( {<Data={"$(=Date(Max({1}today())-2))"}>}ItaliaG)-

sum( {<Data={"$(=Date(Max({1}today())-14))"}>}ItaliaG)

[marcoserilio · Accepted solution]

figure it out. Thanks anyway. I have to get rid of " " to make it work

Sum({<ItaliaG={$(=Max(ItaliaG))}>}ItaliaG)-Sum({<ItaliaG={$(=Max(ItaliaG,10))}>}ItaliaG)