Reversing Signs of Values in Pivot Tables

[MrAccountantMan]

Is there a way to reverse the signs of the data in Pivot Table? I have many columns that are variable each month, so it does not make sense to do calculated fields (equal to the original field *-1); or to change the data in the source.

 

[RonB1111]

You can do a "custom format cells" that will display the opposite sign. Select the cells involved, right-click Format Cells, Number tab, click "Custom", and then in the small box just under the word "Type" on the right side, enter this:
(0.00)_);0.00

Basically, I initially picked a number format that had 2 decimals and then went into custom format and added the () on the left of the semicolon and removed the () from the right of the semicolon. So you can use this technique to select your desired display format 1st and then in "Custom" reverse the () or the - if you prefer the minus sign. The cell value does not change, only the displayed amount has the opposite sign.

 

[Fungie]

Is there a way to reverse the signs of the data in Pivot Table? I have many columns that are variable each month, so it does not make sense to do calculated fields (equal to the original field *-1); or to change the data in the source.

Highlight the pivot table values and right click > Number format

Copy paste this into the Type: field: _(* (#,##0)_);_(* #,##0;_(* "-"??_);_(@_)

(628,338) now becomes 628,338. 30,087 now becomes (30,087).

This is a great tool for P&L data where Revenue is a credit in the GL (CASH IS KING!!) and expense is debit. This reverses the signs so Revenue is now a positive number and expense is now a negative number...which is how most people think of it - and people like having a POSITIVE Net Income number...even though the GL shows it in negative.

Debit CASH, Credit Revenue
Debit Expense, Credit CASH