I’m trying to bring in a spreadsheet into a Base.
Each month, we pull a report that tells us how many people, per department, we have.
Department 1 = January '19 has 32, December '18 has 28, November '18 has 34
Department 2 = January '19 has 88, December '18 has 64, November '18 had 100
We create a column for each month and put that data in the column
We do this every single month, so that means we are adding a new column with the newest data.
I need to calculate the difference between the current month - past month.
Column 1/2019 - Column 12/18
I then need to calculate the difference between the current month - 2 months prior
Column 1/2019 - Column 11/2018
How do I do this, knowing that the column is going to change every single month when we add the newest month column?
I need to create filters that show me entries that increase and decrease, based off the formulas created above.
Is this even possible?