listbox expression?

[#1]

Hi i have 2 dimensions,  product,sales

product:

apple

banana

mango

orange 

sales:

100

200

300

400

dimension is product and sum(sales) as expression in barchart .

here my req is when i click on   mango selections should not happen?need to show orange sales(400)  not mango

for orange, orange sales only

it means i want delete the record called mango here ? how to delete record in listbox? 

[its_anandrjs]

Hi,

There are two ways for this

1. Create the list box by ignoring the mango selection and do not load in the list box by using calculated dimensions in the properties of the list box expression

=if(product<>'mango',product)

2. In the Bar chart use expression

=if(GetFieldSelections(product)='mango',Sum({<product={'orange'}>}sales),Sum(sales))

Regards

Anand