P function with multiple fields

[19iv1987]

Hi, I need to keep fixed a calculation in a textbox for all filters except for three filters.

I already used P function but it seems not working with multiple fields.

Anyone can help me?

Thanks in advance

Eva

[sunny_talwar]

Try with $:: may be

Sum({<Field1 = $::Field1, Field2 = $::Field2, Field3 = $::Field3>}Measure)

[Anil_Babu_Samineni]

I would love to go (P) option, But unfortunately it won't

Other approach could be using {1}

Like(Added one on that, It will give constant value for you)

Count({1<Month = :: Month, Year = ::Year >}Sales)

[Anonymous]

Hi Eva,

Can you share the expression? What do you mean by keeping fixed? To not take in consideration the selection of the fields?

Have you tried:

sum({Customer=,Year=,Month=} Sales). this will give you the sales, no matter what Customer, Year, Month you select.

If this is the case, you can put in the set analysis the fields fixed with "=", except for three filters.

Best regards,

Cosmina

[19iv1987]

Hi Sunny,

It seems not working, maybe it needs 1 somewhere..

[sunny_talwar · Accepted solution]

Hahahaha yes

Sum({1<Field1 = $::Field1, Field2 = $::Field2, Field3 = $::Field3>}Measure)

[19iv1987]

Sunny with 1 at the beginning it works!thanks a lot

[19iv1987]

Hi Cosmina, thanks for the answer but I have to much fields to lock so your method it's quite expensive for me

[sunny_talwar]

Super cool