gmooney
Active Member
- Joined
- Oct 21, 2004
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
I have a pivot table that is showing sales for some rows as well as the % of total sales for those same rows.
I do this for this year and last year time frames.
I want to be able to have a calculated field that show what the point difference is between a row's this year percent of total against last year's % of total.
<tbody>
</tbody>
Can this be done in a pivot table?
I do this for this year and last year time frames.
I want to be able to have a calculated field that show what the point difference is between a row's this year percent of total against last year's % of total.
Item | Sales - This Year | Sales - Last Year | % of Sales - This Year | % of Sales Last Year | Pt Difference |
A | 65 | 60 | 65% | 60% | +5.0 |
B | 35 | 40 | 35% | 40% | -5.0 |
Total | 100 | 100 | 100% | 100% | 0 |
<tbody>
</tbody>
Can this be done in a pivot table?