Thursday 3 December 2015

Want to analyze the data like Sales Variance Percentages from previous year to current Year.

1) Create a Calculated field to get the "2014 Sales" as the following screen shot.

t4.PNG
2) Create a Calculated field to get the "2015 Sales" as the following screen shot.
t5.PNG

3) Create a Calculated field to get the "2014  - 2015 Sales Variance" as the following screen shot.
t6.PNG

4) Right click on "2014  - 2015 Sales Variance" ,  then click on "Default Properties", then click on "Number Format".
t8.PNG
6) Then select "Percentage" as the Data format.
t9.PNG

7) now add all the Calculated fields.
t7.PNG


No comments:

Post a Comment