Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi,
try this
=Sum({1<[Date]= {"=$(=Max_Cal_Date)"}>}Sales)
The 1 ignore all selections.