Set Analysis AND??

[feg]

HI all,

I would like to create a set expression that return:

sales for for all the customers that were in region A in the month of October and in the region B in the month of November.

Amy idea?

fb

[sunny_talwar]

May be this:

Sum({<customers = p({<Region = {'A'}, Month = {'Oct'}>}) * p({<Region = {'B'}, Month = {'Nov'}>})>} sales)

[Chanty4u]

chk dis

Sum({<fileld = p({<region = {'values'},[ month field] = {'monthname'}>}) sales)

Excluding values in Set Analysis

[martinpohl · Accepted solution]

use this expression:

sum({<Region={A},Month={October}>+<Region={B},Month={November}>}Sales)

Regards