Exclude values in Dimension by deselect another

[madmax88]

Hi,

I have following Dataset

Container	Position	Value
A	P1	1
A	P2	200
A	P3	50000
A	P4	1000
A	P5	10
C	P1	2
C	P2	1000
C	P3	50000
C	P4	1000
C	P5	10
D	P3	500
D	P4	200

I need now a Dimension, where I can select between following Containers:

Container are selected where..

1) there is no P1

2)  the Value of P1 is greater than 0 but smaller than 2.

3) The Value of P1 is greater or equal than 2

At the Moment I have tried the the Dimension Selection for Selection 1 (I havent' found a selection for 2 and 3) :

IF(len(P1)='0','Selection',

IF(len(P1)>'1','No Selection'))

e.g. click on "Selection" it shows me the Container Value without the P1 value. But in this case it should show me only the container D where no P1 value is available. Is this possible?

[OmarBenSalem]

Try as follow:

=aggr(
if(Position<>'P1','No P1',

if (sum({<Position={'P1'}>}Val)<2,'P1 smaller than 2',

if (sum({<Position={'P1'}>}Val)>=2,'P1 greater than 2'
)))
,
Container,Position)

result :

Select "No P1":

P1 greater than 2 

P1 smaller than 2

[madmax88]

Thanks for your reply!

At the moment it does not work but I'm checking my data model and try something. I'll let you know when i know more.

Anyway: I have now a 3rd variable: Customergroup. Is it correct when I write:

if(POS_NAME<>'P1' and Customergroup="*ABC*", No P1',