Some filters must apply to sum(quantity), others must not

[salto]

Hello all,

I have a table with this fields: ProductID, Quantity, Date, FailureCode, EmployeeID.

I want to show two columns: one of them is the sum(quantity) field, on which ProductID, Date, FalireCOde and EmployeeID fIlters must apply.

The other column has to show the sum(quantity) , but only the ProductID and Date filters must apply in this second column.

Do I have to make two separate loadas of this table? In that case, how do I link them?

Many thanks in advance-

[Anonymous · Accepted solution]

This is where set analysis can help. If you want an expression to be independent from some fields, it will be:
sum({$<FalireCOde=, EmployeeID= >} quantity)

[marcel_olmo]

Why don't you use a simple table with set analysis?¿

If you don't want the filters affect the final result, you have to put the fields in the set analysis like the following :

sum({$ [myExcludedField]=} mySumField)

Hope it helps!!

[martinpohl]

Hello SALTO,

try in the second column

sum({<FailureCode= , EmployeeID= >} yourfield)

Regards

Martin

[salto]

Many thanks for your quick and accurate response. It works great now.