pre selection independant from active selection

[employe4_2]

HI ,

i'm using this expression to have my sum of sales per date on a specifique periode of time ( where max_cal_date  give me the last 3 loaded days):

sum(if ([Date]= Max_Cal_Date, Sales,0))

but at this point i'm willing to make it independant from the active selection,

if the user select some other days, i would like my chart NOT to take it in consideration.

Because this chart is made to display the last 3 days, whenever the selection made is out of these 3, the intire chart desappear, wich is not the goal.

I saw on an other post to add: + sum({1}0) 

but not working, any advice ?

[Anonymous]

Hi,

try this 

=Sum({1<[Date]= {"=$(=Max_Cal_Date)"}>}Sales)

The 1 ignore all selections.