Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all Gurus,
I set up a Label in Pivot as a formula to dynamically display my selection.
Now I want to use it as a parameters in an expression. Can anyone please show me the way to put it?
Example: I want to use the result of Year 2012 as a parameter in a sum. How to put ='Year'&' '&(max(Year)-1) in another expression?
hello
why don't you use the notation column() in your sum ?
suppose column Year 2012 is 4th column of you chart, then you can code sum(column(4))
Hi Olivier,
The number of column is variable. I use conditional to hide/unhide to add up or deduct the columns I want. So the number of order is not fixed.
Any suggestion in this case?
and did you try to use the $(=) notation ?
something like
=$(='Year' & max(...))
I tried to put it in several ways with dollar sign but didn't work
>>I want to use the result of Year 2012 as a parameter in a sum.
That's a little vague. I suggest you provide more specific information, including information on the underlying data, the expression(s) you have tried and what result(s) you need.
>>I tried to put it in several ways with dollar sign but didn't work
What did you try? Its hard to help debug an expression that is not shared.