2 Replies Latest reply: Apr 23, 2012 3:08 AM by Alwin Scheerens RSS

    Set fieldname in manual Variable for use in pivottable

    Alwin Scheerens

      Hi,

       

      I created a button, on which i put an action setting the value of variable

      but in that variable i want to store the name of a field used in my import script

      So later on i can use my variable in a pivot table

       

      for example

      - action on button --> = if(V_NP = NP, NP, Comm)

      - NP and Comm are fields  of my import script

       

       

       

      in my pivot table i want to create an expression

      =sum(V_NP)

      --> and the result depends on the value of V_NP, to which field it points at the import script

       

       

      How can i do this?

       

      Kind regards

      Alwin