How to insert multiple selections in an IF statement for a SUM expression?

[jblomqvist]

Hi there,

I am trying to do something like this:

Field:

Category: Product 1, Product 2, Product 3, Product 4, Product 5

Year: 2012, 2013, 2014

What I want to do is this:

If a user selects Product 1 and Year = 2012, then Sum 1 expression

If a user selects Product 2 and Year = 2012 then Sum 2 expression

If a user selects Product 1, Product 2, and Product 3 and Year = 2012 then Sum 1 expression.

Does anyone know how to write an If statement or a check like this?

[Digvijay_Singh]

You can put these conditions as  expression's conditon box after clicking on Conditional check box  in expression tab of a straight table. Check this sample -