Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have created a pivot table , looking for solution to give % of change
Data:
Sales rep | Year | Sales |
---|---|---|
John | 2014 | 100 |
John | 2015 | 150 |
Pivot Table
Sales Rep | 2014 | 2015 |
---|---|---|
John | 100 | 150 |
Output: a row giving % difference of sales over previous year
es Rep | 2014 | 2015 |
---|---|---|
John | 100 | 150 |
% Change | 0 | 66.7% |
Does this help? PFA
Best,
Sunny