Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Henry,
try to create a pivot table with dimension Clients and expression
sum( {<Salespeople={'A', 'B'}>} Sales)
Regards
Luca
Hi Henry,
try this:
element_function ::= ( P | E ) ( [ set_expression ] [ field_name ] )
thanks