Limit pivot formula calculation to specific filters

[hugmarcel]

Hi

I have a pivot and fields Field1, Field2, Field3, Field4, ...., Fieldx in my datamodel are filtered.

How in the pivot, can I define a formula where only filters of Fields Field1 + Field2 should apply (all other filters should be ignored)?

E.g.

sum( {1<Field1= {all_selected_values_of_Field1},Field2= {all_selected_values_of_Field2}, >} Assets )

Thx - Marcel

[giakoum]

sum( {1<Field1= {"=$(getfieldselections(Field1, ',')"},Field2= {"=$(getfieldselections(Field2, ',')"} >} Assets )

Hope that I have the syntax correct!

If nothing is selected this will not work, but you may use the concat function instead.

Of course you could go the other way around, but it looks like a lot of trouble, ie :

sum( {$<Field3=,Field4=,Field5=, etc etc  >} Assets )