dynamic Status_Show Names with Status "x" or "y".

[jakobjosef]

Hello dear QV-Community,

may I ask you for help?

Following problem:
I would like to show the sales-value of all employees with the status "planned" and the status "unplanned".

I am able to manage to show them separately (one table for planned one for unplannend).

My dynamic dimension is like:

=if ( status = 'planned', employeeName)

for values it s just "Sum(Sales)".

this works for  'unplanned' as well.

I would like to show 'unplanned' and 'planned' in one table, so i tried to type my dynamic dimension like:

=if (status = 'planned' or 'unplanned', employeeName).

But unfortunately this doesnt work. Does anyone know who I can combine both statuses?

Thank you for your help.

Greetings
Jakob

[sibin_jacob · Accepted solution]

Write like this

=if (status = 'planned' or status ='unplanned', employeeName).

[Anonymous]

Try using the code below:

In 'Dimension' tab, add a calculated dimension and type the following:

=value list('Planned', 'Unplanned')

In 'Expressions' tab, add the following two expressions:

1. if(value list('Planned', 'Unplanned')='Planned', sum(if(status='Planned', Sales)))

2. if(value list('Planned', 'Unplanned')=Unplanned', sum(if(status='Unplanned', Sales)))

[jakobjosef]

i already solved it on my own:

=if(status = 'planned' OR status = 'unplanned', employeeName)

[jakobjosef]

THANK YOU so much for your quick(view) help