Detecting current column in Expression Text Colour
Having found out that the Visual Cues are not able to process expressions on the chart's row level I am now setting up colours under the Expression's ( + ) symbol.
I would like to still have the sort of flexibility Visual Cues provides where I don't need to reference the calculation I am testing against. What I mean by this is I would like to reference the column value in the simplest way possible.
I realise I can use with the Column(ColumnNo) syntax, or the Columns label, but neither of these fits my purposes. I am setting up the various columns to not be calculated and hidden, based on user button selections and the available data, making tests for Column(ColumnNo) is a problem. As my column labels are dynamically set with date ranges and notification of their being "Full Month" or "MTD" etc, using column labels is also not an option.
Is there a way to test for the value in the column I am currently changing the text colour of. I have tried Column(ColumnNo()) as I understand ColumnNo() should return the position of the column, working from left to right. However, I can't get the ColumnNo() function to return me the position of the table's column using the expression "=ColumnNo()" in either a pivot or a straight table.
Seems that following your example wasn't as powerful as I hoped. I was expecting this syntax to allow me to:
1. Reference the current column from within it's Text Colour expression
2. Use the column label in other expressions to calculate MTD vs. LMTD etc comparisons
Am I doing this correctly. I set up a variable called:
Using this formula:
='MTD to '&MTDEnd
To create a label that looks like this:
MTD to 16/10/2012
I then reference this within it's own Text Colour using the following syntax:
This doesn't work for me though. I have also tried with quotes around the $(), not having the equals sign in the $() and removing the $() expansion entirely. I have also tried these tests when assigning the ColMTD within another field, and not just i the TextColour expression.