how to exlude filter on expression

[#1]

Hi guys, i've a littl bit problem(i hope)

I've got one expression and i need to exclude every filters i've in my project,but i've to mantain only one of them

i know i can use expression looks like sum( total <Filter1,Filter2,...,...,...FilterN> Sales ) by exluding the filter i don't need.

but i've a lot of filter to in my project and it should be better i can specify only this one to be used on my formula.

In substance i'n searching for an expression like this, but that it works on the contrary....

thx a lot.

bye.

[Gysbert_Wassenaar]

you can use a subset expression; sum( {1} Sales) will disregard selections and calculate the sum over your dimensions.

[#3]

thx, bu ti need to disregard all selections exept only one.....

[Gysbert_Wassenaar]

sum({$<Field1= , Field2= }>} Sales) will disregard selections for Field1 and Field2. You can add all the fields that need to be disregarded.

[#5]

ok, but i've a lot of field to add, meanwhile i want to make the contrary, add the only one filter to be considered

[MayilVahanan]

HI

Try like this

=sum({1<FieldToKeep=P(FieldToKeep)>}Sales)

Hope that helps

[Gysbert_Wassenaar]

Maybe something like sum({1<Field1=P()>} Sales). If I understand it correctly this would disregard all selections except the selections for Field1

[#8]

tried, but not works fine....it consider other selections too, seem to be not works 1 value to have totals...