0 Replies Latest reply: Apr 25, 2012 5:37 AM by Uday Kumar RSS

    Show only excluded values in listbox based on other listbox

    Uday Kumar

      hi

       

      i am using an expression to show excluded values like this

       

      =aggr(only({1-$}PRODUCT_NAME),PRODUCT_NAME)

       

      but the PRODUCT_NAME depends on the market_name.

      so if we change market_name, then the product list changes dynamically

      so i dont know to apply second filter to this expression.

      can anyone help me?

      i need to add market_name filter to this expression, but i dont know where to add it exactly