Add target in pivot table

Add target in pivot table

Hi,
I have a pivot tabel with achieved sales per employee (column) and per producttype (row). The pivot table shows Grand total of sales per person.


employee 1
employee 2
product 1
10
20
Product 2
30
10
Product 3
20
40
Grand total
60
70

Is it somehow possible to add a row with the target per sales person and the remaining sales?


employee 1
employee 2
product 1
10
20
Product 2
30
10
Product 3
20
40
Grand total
60
70
Target
100100
Remaining
4030

Thanks!

PS I know it's possible to add a target in a chart, but I would also like to add a target in a pivot table.