Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you share your sample apps?
May be we can achieve by using Dimensionality and Set Analysis.
you can copy the same column & then add conditional expression.
One with < 0
Other with > 0
the TOTAL column is a a partial sum column. How to copy the same column ? Plz find below the screen shot