Two conditions to count the sum

[#1]

Hi guys,

I have the following table:

I apply the condition: SUM({<[Month]={'1'}>} [Amount]) and get this:

For the second table I need to count the sum of amount with only indexes A, B, and C, but the statement

=sum( {<[Index]={'A','B','C'}>}  {<[Month]={'1'}>}   [Amount]) doesn't work.

As a result I need to get in the text object the sum = 68

Does anybody have some ideas how to apply to conditions to get the right answer?

Thanks a lot for anysuggestions in a advance!

[Anonymous · Accepted solution]

Hi Alexander,

try this:

sum( {$<[Index]={'A','B','C'},[Month]={1}>}   [Amount])

​Hope this helps

[#3]

Yes, it works! 😃 Thanks a lot !

[Anonymous]

No problem, happy to help!