gmooney
Active Member
- Joined
- Oct 21, 2004
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
Hi,
I have a data table where I have sales for an item in 1 row called focus (that is this years sales) and then the next row gives me the comparison sales (this is last years sales for that item).
I am putting a pivot table together that looks like this but have not been able to figure out how to get a simple calculated field or item that would be this: Sales Change = Sales for Focus - Sales for Comparison.
I would then like to do a formula to get the sales % change: Sales Change/Sales Comparison.
See the picture of my pivot table layout.
I have a data table where I have sales for an item in 1 row called focus (that is this years sales) and then the next row gives me the comparison sales (this is last years sales for that item).
I am putting a pivot table together that looks like this but have not been able to figure out how to get a simple calculated field or item that would be this: Sales Change = Sales for Focus - Sales for Comparison.
I would then like to do a formula to get the sales % change: Sales Change/Sales Comparison.
See the picture of my pivot table layout.
