10 Replies Latest reply: Nov 13, 2017 4:15 PM by Christian Reed RSS

    Get Column Number

    Cristina Chiriac



      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:



      -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.