1) Create a Calculated field to get the "2014 Sales" as the following screen shot.
2) Create a Calculated field to get the "2015 Sales" as the following screen shot.
3) Create a Calculated field to get the "2014 - 2015 Sales Variance" as the following screen shot.
4) Right click on "2014 - 2015 Sales Variance" , then click on "Default Properties", then click on "Number Format".
6) Then select "Percentage" as the Data format.
7) now add all the Calculated fields.
No comments :
Post a Comment