8 Replies Latest reply: Jul 18, 2014 10:16 AM by Sudeep Mahapatra RSS

    Set Analysis with a variable in the filters (possible?)

      Dears, I would like to do a set analysis using variables, but the variable would be the filter of the formula, for example:

       

      This is the normal

      =Sum({$<PRODUCT_FAMILY={"Family"}>}($(vInvoice))


      I want to use the variable in the <  > (in the place of PRODUCT_FAMILY)


      How do I do that?