Calculated Dimension Showing ONLY Possible Customers

[#1]

I have a population of Clients and Salespeople.

In my calculated dimension, I'd like to only show the Clients that have Sales with only Salespeople A and B.

I'm thinking of using the p function but am having problems with the syntax. Can anybody advise? Thanks in advance!

[pljsoftware]

Hi Henry,

try to create a pivot table with dimension Clients and expression

sum( {<Salespeople={'A', 'B'}>} Sales)

Regards
Luca

[#3]

Hi Henry,

try this:
element_function ::= ( P | E ) ( [ set_expression ] [ field_name ] )

thanks