Customized sales tracking report

[funksoul]

Hi guys!

I had always found tips and tricks here so i just wanted to ask about yours opinion because i am stuck at the moment with this.

Goal: One pivot with additional calculated field - targets vs actual (sales data), per SKU, per customer, per employee.

I have:

1st sheet, its external source data with unique customer ID, SKUs, sales data, monthly

ID Lanac Ime preparat Jan Feb Mar Apr May Jun Jul Avg Sept Oct Nov Dec 5 Customer1 Employee1 SKU1 3 5 5 342 3 324 42 3 324 42 1 321 5 Customer1 Employee1 SKU2 3 2 342 3 324 42 342 3 324 42 21 312 5 Customer1 Employee1 SKU3 214 3 42 2,344 34 2 34 2,344 42 2,344 34 2 5 Customer1 Employee1 SKU4 1,243 12 342 3 324 42 2,344 34 2 34 24 324 5 Customer1 Employee1 SKU5 321 3 432 423 324 3 2 32 4 432 43 43 5 Customer1 Employee1 SKU6 312 231 321 321 32 432 532 3 342 342 42 324 <tbody> </tbody>

<tbody>

<tbody> </tbody>

<tbody>
</tbody>

</tbody>

*random actual sales number per months

2nd sheet, its internal source data with unique customer ID, SKUs, sales target data per SKU, per employee, monthly

ID	Lanac	Ime	preparat	Jan	Feb	Mar	Apr	May	Jun	Jul	Avg	Sept	Oct	Nov	Dec
5	Customer1	Employee1	SKU1	3	5	5	342	3	324	42	3	324	42	1	321
5	Customer1	Employee1	SKU2	3	2	342	3	324	42	342	3	324	42	21	312
5	Customer1	Employee1	SKU3	214	3	42	2,344	34	2	34	2,344	42	2,344	34	2
5	Customer1	Employee1	SKU4	1,243	12	342	3	324	42	2,344	34	2	34	24	324
5	Customer1	Employee1	SKU5	321	3	432	423	324	3	2	32	4	432	43	43
5	Customer1	Employee1	SKU6	312	231	321	321	32	432	532	3	342	342	42	324

<colgroup><col><col><col><col><col span="12"></colgroup><tbody>
</tbody>

*random targets sales number per months


Thanks in advance for ideas.