I have a pivot table which shows sales by customer by year. I created a field to show the difference in sales year over year. Is there a way to only show the comparison field once? It currently shows up in both 2009 and 2010. Also, I want to then sort the table by the difference in sales. This all seems basic to me but I can't get it to work. Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pivot Table Formula
- Thread starter lcmast
- Start date
