9 Replies Latest reply: May 25, 2017 5:21 AM by I. Sorin Rusu RSS

    Get Column Number

    Cristina Chiriac

      Hi,

       

      I have a bar chart with 4 expressions and no dimensions. It shows a bar for each one.

      My expressions are: Reg1, Reg2, Reg3, Reg 4.

      I know that i can reference these values in another expression by the function Column(). Like when i want a total in the chart i can use:

      -column(1)+....+column(4)

      or

      -Reg1+..+.Reg4 (using the names).

       

      How can i get the number of the columns? How can i be sure that Reg1 is column(1)?

      Is there a formula that calculates the number of column Reg1 (which is also the first expression)? I am thinking about ColumnNo(Reg1) but it doesn't work.