LtCmdrData
Board Regular
- Joined
- Jan 24, 2018
- Messages
- 58
- Office Version
- 365
- Platform
- Windows
Hello,
I am trying to calculate the percentage change between two columns of data. Everyday I get sales data and I am trying to compare today's sales to yesterday's sales. The pivot table is simple: The sales item and division that sold it in the Rows, Date (Yesterday and Today in Columns), and the quantity sold (sum) in the Values section. How can I add another column to the pivot table that shows a percentage change for each item and division right beside the two Date columns? The data is housed in one table; one day's data stacked on top of the other day's data.
As a side note: I'm storing each days data in a folder and using Power Query to pull the last two files from the folder and put them into a pivot table. This way I can just refresh each day and see the changes. Thanks for any help and suggestions.
I am trying to calculate the percentage change between two columns of data. Everyday I get sales data and I am trying to compare today's sales to yesterday's sales. The pivot table is simple: The sales item and division that sold it in the Rows, Date (Yesterday and Today in Columns), and the quantity sold (sum) in the Values section. How can I add another column to the pivot table that shows a percentage change for each item and division right beside the two Date columns? The data is housed in one table; one day's data stacked on top of the other day's data.
As a side note: I'm storing each days data in a folder and using Power Query to pull the last two files from the folder and put them into a pivot table. This way I can just refresh each day and see the changes. Thanks for any help and suggestions.
