A aggie81 Member Jan 27, 2016 #1 I want to calculate the change in customer sales comparing 2014 to 2015 sales data using a Pivot Table. 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
I want to calculate the change in customer sales comparing 2014 to 2015 sales data using a Pivot Table. 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
Luke M Excel Ninja Staff member Jan 27, 2016 #2 Right-click on cell A4 (Item Sales). go to Value Field Settings. Click on 'Show Value As' tab. Set options like this: Ok out. Before and After using my data:
Right-click on cell A4 (Item Sales). go to Value Field Settings. Click on 'Show Value As' tab. Set options like this: Ok out. Before and After using my data: