Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table with many dimensions. The resulting expressions for some of these dimensions will be displayed as minus values.
For certain dimensions - some of these minus values need to be displayed as a bracketed value and the text in Red.
eg
-15 will need to be shown as
(15)
Is this easy to achieve??
Many thanks
Tom
Hi Tom
your expression must be
='(' & fabs(sum(value)) & ')'
and in proprerties set if(value <0, red()) or use visuals cues
best regads
Chris
1. Make your dimension look like this so that it wraps it in the parentheses:
=num(Value, '###########,###;(###########,###)')
2. Put a text color expression on the dimension like this:
Example file is attached.
here is an example Expression
then using visual cues tab, you can change it to Red if it's negative