1 Reply Latest reply: Feb 10, 2014 4:59 AM by Nagaraj Rangaiah RSS

    Expression with current/relative position

      Hello,

       

      I have a list of 50 measures, I need to change my pivot table, to add the ratio of each of this measure on [NET SALES].

      To reference an expression, I can ether use its label ex: =[NET SALES] or its position = Column(1)

       

      I assume I will have to add 50 entries in my pivot table, but I wish they share the same formula (that I can put later as a variable) such as

      =Column(CurrentPosition-1)/[NET SALES]

       

      How can I retrieve the current position of an expression?

       

      NET SALES
      Cost of Sales
      %NET SALES=[Cost of Sales]/[NET SALES]
      Warehousing
      %NET SALES=[Warehousing]/[NET SALES]
      Freight & Delivery
      %NET SALES=[Freight & Delivery]/[NET SALES]

      ...