Reverse sign - condtionally - on numbers in Excel pivot table
Posted on 2010-08-21
How do you reverse the signage on a number in a pivot table - based upon some condition.
Crystal Reports has a simple reverse sign display, and you can create a condition for that formatting. I was hoping for something this simple.
Everything I have researched on the internet discusses multiplying by -1..... however that changes the integrity of the number - and would be overwritten if you were to paste the values.
In a pivot table, you need to add numbers based upon the actual signage..... however for financial statements, you would show expenses/COGS as positive numbers, even though they are subtracted in the calculation.