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?

[its_anandrjs]

In expression write your expression like

Count({<Purpose = {'Recovery','User request' >}Your sum or count Value)

Or

If use in dimension then write calculated dimension for Purpose

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

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

Or

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

[arsal_90]

use this in chart dimension

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

or if(Purpose='Implementation','',Purpose)

[#4]

I did the way u taught, but i also want to remove implemented char.   

[arsal_90]

Can u share the image after implementing my script and please clear what exactly you want

[jagan]

Hi,

Try like this

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

OR

Sum({<Purpose = {'Recovery','User Request' >} MeasureName)

Regards,

Jagan.

[#7]

I want to remove the chart of implemented(the red color one)

[arsal_90]

whats you expression can u share me

[arsal_90]

can u post your qvw

[#10]

[jagan]

Hi,

Did you tried filtering using Set Analysis instead Dynamic Dimensions like this

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

OR

Sum({<Purpose = {'Recovery','User Request' >} MeasureName)

Regards,

Jagan.