fix filter

[#1]

Hi there,

Im my model I would like to have a fix filter on one sheet , regardless of what the user is choosing, The only field that change will be the date field.

example ...

I want to do the sum always when Cores is <=4  but when Status is base then sum Processor *.20 and when Status is New then just sum processor. But I want the values to change based on the date the user selected

sum(if(cores <=4, processor * if(Status='Base',0.20,if(Status='New',1,1))))

[Gysbert_Wassenaar]

Try something like: sum({1<Date=p(Date)>}if(cores <=4, processor * if(Status='Base',0.20,if(Status='New',1,1))))