How to add an additional column in pivot table.

[#1]

We have a column in the Pivot table "TOTAL", which has both +ve and -ve values. Now we need an adjacent column which should only show +ve values from the TOTAL column and all the -ve values as 0.

Need help on how to do it.

[MK_QSL]

Can you share your sample apps?

May be we can achieve by using Dimensionality and Set Analysis.

[manojkulkarni]

you can copy the same column & then add conditional expression.

One with < 0

Other with > 0

[#4]

the TOTAL column is a a partial sum column. How to copy the same column ? Plz find below the screen shot