• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculated Field from year change

aggie81

Member
I want to calculate the change in customer sales comparing 2014 to 2015 sales data using a Pivot Table.
upload_2016-1-27_12-40-22.png
I can't get figure out how to do it.
Any help is appreciated.
The data is pulled in using Power Query from SQL database.
Thanks,
Lee
 
Right-click on cell A4 (Item Sales). go to Value Field Settings. Click on 'Show Value As' tab. Set options like this:
upload_2016-1-27_14-45-19.png

Ok out. Before and After using my data:
upload_2016-1-27_14-46-36.png
 
Back
Top