New Calculated Item with Conditional Format
Alex1Feb 10 2009 — edited Jul 1 2011Hi friends!
My question is simple. Is possible to apply conditional format in a calculated item that I have created in a pivot table?
Only I want to apply conditional format in my calculated item
On my example I have
--------------------year1------year2----dif(my calculated item)
measure1-------100-------50---------50
measure2-------75-------100---------(-25)
I want if my dif is >0 green colour and if <0 colour red but only in my dif column, if I put this in my measure (criteria tab) works but I have all values in green or red depends my condition...
Thank you!