Pivot Table Flip Signs

[rjacmuto32]

I have a large spreadsheet with a lot of data and columns. I have a pivot table to sum all that up however I want to flip all the signs in the pivot table. Meaning 300,000 should show as -300,000 and then say -6,667 should show as 6,667. Is that possible.

I used the pivot table formatting with this #,##0;#,##0 but it was only able to make everything positive. So it made the -6,667 a 6,667 but it didn't make the 300,000 into a -300,000.

Is there a way to do both?

 

[jeffreyweir]

Try -#,##0;#,##0

 

[NARAYANK991]

Hi ,

Isn't that dangerous ? A pivot table is supposed to represent raw data in the correct manner ; to change the format only in the pivot table is , in my opinion , not correct.

An alternative would be to introduce 2 additional columns in the raw data , with the appropriate labelling , and then use these columns in the pivot table ; the advantage of this would be that at a later date if you wish to revert to a normal display , all you have to do is select the proper columns to display in the pivot table.

Narayan

 

[jeffreyweir]

Maybe the labelling is already correct, and the data wrong. Otherwise Narayan raises a good point...better to amend the data, not the Pivot.