Sum if 2 conditions with selections

[#1]

hi,

now i have such formula :

sum({<Year={'$(=max(Year)-1)'}>} [liters purchased])

so when i have selected Year 2011, this formula me returns previous year 2010, not looking that i have selected Y2011. - it's OK.

now i want to add additional rule , also that should not look at selections. i have Local or Export sales, so i would like to add additional rule in this formula , is it possible ? so should be something like that : {<Year={'$(=max(Year)-1)'}>} { .... local...} [ liters purchased] .. ?

[lironbaram · Accepted solution]

hei

yes you can add as much conditions as you like

it will look like

sum({<Year={'$(=max(Year)-1)'},KindOfSales={"local"}>} [liters purchased])

[#3]

Super, Thanks !

it works 🙂