BloodyBill
New Member
- Joined
- Oct 5, 2020
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hi,
So I collect a lot of raw data into a pivot table that shows categories and dates. Something like this:
Pivot table
On a separate worksheet there is a whole year's worth of goals on a regular (not pivot) table:
Goal Table
I want to create a third worksheet that finds the actual sales reflected in the pivot table (1/10, Apples = 19) and compares that with the corresponding goal on the static goals sheet (1/10, Apples = 17) and gives the difference (+2). We exceeded goal. (We're behind by 12 on peaches, that day.)
The tricky thing for me is that the dates on the pivot sheet will be constantly changing as the year goes by, while the year-long goal sheet is pretty static. I need a way to go fetch the right date-specific goals to compare to the moving pivot.
Any help? Thanks!
Bill
So I collect a lot of raw data into a pivot table that shows categories and dates. Something like this:
Pivot table
On a separate worksheet there is a whole year's worth of goals on a regular (not pivot) table:
Goal Table
I want to create a third worksheet that finds the actual sales reflected in the pivot table (1/10, Apples = 19) and compares that with the corresponding goal on the static goals sheet (1/10, Apples = 17) and gives the difference (+2). We exceeded goal. (We're behind by 12 on peaches, that day.)
The tricky thing for me is that the dates on the pivot sheet will be constantly changing as the year goes by, while the year-long goal sheet is pretty static. I need a way to go fetch the right date-specific goals to compare to the moving pivot.
Any help? Thanks!
Bill