I want to create a pivot table that summarizes (groups) data from detail and includes a Gross Profit formula for the last column. When I put that formula in the column on the detail side, the pivot table does ugly things with it and I don't get the correct value. Any ideas other than typing the formula in manually on the pivot table side? When I do that, whenever the data is refreshed, the formulas and formatting gets all hinked up.
Thanks (ps I know this isn't a VBA question, if I'm posting an inappropriate question, just ignore me, please).
Margaret
Thanks (ps I know this isn't a VBA question, if I'm posting an inappropriate question, just ignore me, please).
Margaret