Expression

[upaliwije]

SUM( IF(I_DAY > 25, and  max(I_MONTH),  [Amount]))

I have above expression in my pivot table which is not working. My expected result is to sum amount where I_DAY should be more than  25 th and I_MONTH should be I_Month selected by the user. Pls help me

[swuehl · Accepted solution]

If you want the expression to reflect selections by the user, you don't need to do anything, that's QV default behaviour.

So remove the part ', and max(I_MONTH)' [it's not correct anyway].

=SUM( IF( I_DAY >25 , [Amount]))

or maybe

=SUM({<I_DAY = {">25"}>} [Amount])