pivot table result

[aam1932]

Hai,

How to set off all the negative figure if there any positive figure in pivot table for sample item(row)

Example, i seperated the result by item (row) and period by column, currently the result show example period 1 = 6, period 2 = (2), period 3 = 5, and period 4 = 2,

i want the result for period 2 will be = 0, and will set of with the earlier period that mean period 4, that mean should be = 0,

Thank you

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.