Hello friends
The problem I stumbled is the following:
For example: I have planned funds on yearly basis and they are tabled like this: Columns "Service ID"; "Service name"; "Department 1,2 and 3;" and below are the relevant values
On monthly bases I receive reports from departments for the funds been spent. The reports are organized like this: Columns "Service ID"; "Service name"; "Invoice"; 'Invoice date"; "Contractor"; "Department №" and below are the relevant values.
With the reports I don't have problems, I pivot them and I do the monthly reports as required. The problem occurs when I decide to compare planned funds with the spent ones in order not to exceed planned. I cannot figure out how to connect static table (the one with planned funds) and pivot table with summarized expenditures per department; per Service.
I hope the example file is easy to understand and I'd really appreciate ANY hint. I struggle with problem 2 weeks already, I tried many combinations, but no success so far.
Bookmarks