Sales plan vs realisation
Hi!
I have 2 tables, one with sales plan per person per product per month and second one with realisation of sales.
To keep it simple:
Sales plan
Sales realisation
Month | Seller ID | Item ID | Target Value |
Sales realisation
| Date | Seller ID | Item ID | Target Value |
Is there any way to make graph pet Item like
- 1st column = planned amount/sum
- 2nd column = total realisation
- 3rd column = realisation according to plan
- 4th column = realisation in addition to plan (3rd and 4th in total is 2nd)