Replace Minus Values in Pivot

[#1]

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

[#2]

Hi Tom

your expression must be

='(' & fabs(sum(value)) & ')'

and in proprerties  set  if(value <0, red())  or use visuals cues

best regads

Chris

[Nicole-Smith]

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.

[rustyfishbones]

here is an example Expression

then using visual cues tab, you can change it to Red if it's negative