graph showing last 60 days

[chriscools]

Hello,

how should i adapt my formula if i only want to show sales during the last 60 days?

Sum ({<Shop= {'Pomax Store Wijnegem'}, Year= {"2012"}>}LineSalesAmount) 

i also want to include an extra line showing only the sales from today minus 1 year and then also 60 days back...

thanx!

grtz,

chris

[SunilChauhan]

add extra fields which are for selection like below

Sum({<Shop= {'Pomax Store Wijnegem'}, Year = {$(= Max(Year))}, Date = {">=$(=Date(Max(Date)-90)<=(=Date(Max(Date))))"},Date=,Year=,Shop=....  >} LineSalesAmount)

you can add like above  Date=,Year=,Shop=, and whatever field you dont want to affect this sum

hope this helps