I have pivot table that looks something like this: Cost of Sales Others & Expenses are negative so that the Subtotal & Total are calculated correctly.
I know you can show the negative either in red (with a minus sign in front) or in financial style. But is there anyway to get rid of the positive sign but still making sure that the Subtotal and Total rows are correct?