I'm trying to write an expression which uses default filters and alternative filters.
default filters are [Site] and [transaation date]
alt filters are [transaction date]
current expression is
sum({<[Product Division Type] = {'Food'}>}[ Net Sales])
what i want to do is keep the fixed [product division type], keep the [site] but use the alternative [transaction date]. the idea is to get the above expression less the alternative date expression to get a variance, without having to select all the parts as alternative filters.
Thanks