Is it possible to remove one value in listbox?

[#1]

Hi~~i want to know that is it possible to remove "implemented" in the listbox of "Purpose".

Do i need to change in script? But in the script, it just show like this:

So, what should i do?

[arsal_90]

=AGGR(ONLY({<Purpose-={'Implementation'}>} Purpose ), Purpose )

OR

=Aggr(Only( {< Purpose = p( Purpose ) >} Purpose ), Purpose )

[#3]

use Where Condition

Table:

Loald *

From yourSource

Where Purpose <>'Implementation';

[#4]

Just change your list box to use an expression, add the following as your expression  =if(Purpose <> 'Implementation', Purpose)

[manideep78]

Use where Clause in the script :

WHERE Purpose <> 'Implementation' 

             OR

Use Expression in List Box:

=if(Purpose<>'Implementation',Purpose)

[its_anandrjs]

Yes in list box in expression type like this

In Front use like

1.

If(Purpose='Recovery','Recovery',

If(Purpose='User Request','User Request'))

Or you can write in list box expression

2.

If(Purpose <>'Implementation',Purpose)

3.In the load script like

Load

Fields

..

..

From Location

Where Purpose <>'Implementation';

Regards

[arsal_90]

Go to list Box and then in general tab in drop down go to expression and then in expression you have to write this

=AGGR(ONLY({<Purpose-={'Implementation'}>} Purpose ), Purpose )

OR

=Aggr(Only( {< Purpose = p( Purpose ) >} Purpose ), Purpose )

[#8]

Thank u for ur help! But it's not correct.May be i did not make it clearly, i just want to look at "Recovery" and "User request" in the chart exclude "Implemented"

[#9]

Thanks! But it doesn't work. May be i did not make it clearly, i just want to look at "Recovery" and "User request" in the chart exclude "Implemented"

[manideep78]

Take Month as Dimesion and take two expressions:

Count({<Purpose={'Recovery'}>}Purpose)

Count({<Purpose={'User Request'}>}Purpose)