Up/Down arrow based on pivot table which is using Valuelist
I have pivot table something as below. I want to show UP/Down arrow next to each of the measures. So the condition is if measure >=0 then UP Arrow(In Green) and if the measure is less <0 then DOWN arrow(In Red).
Since I have been using Valuelist here I am not sure how to achieve this here.
How's this, I think it covers all of your requirements... (see attached qvw).
The up/down arrow is in a separate column from the values
The up/down arrow is coloured green/red while the value is not
The column names for the arrow columns are hidden
I ended up storing the expressions in variables, otherwise the expressions used for the arrows/colours would be unreadable. I'm still not really behind this solution, I think it would be a lot simpler to do what I originally suggested and create expressions for the arrows instead of adding them to the dimension list, or to do what HirisH suggested and calculate everything in script.
I hope this is what you were looking for. I can help you change the colours of the arrows if you'd like but I think other than that if this still doesn't fully cover what you were looking for I'm tapping out of this one.
Yeah I tried fixing this as well but couldn't find a solution for it. Problem is that the arrow column and the value columns are both the same dimension so it is only possible to set 1 column width (and I don't think you can base the column width on an expression).