1 Reply Latest reply: Oct 7, 2013 8:41 AM by Gysbert Wassenaar RSS

    fix filter

      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))))