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.
Thank you Stefan! Your formula can get a bit messy, but it really works! Thank you! I siplified it a little and it seems to work, just replace 'XY' with your desired column's label formula.
