One way to do it would be to consolidate the information from table 2 to table 1 and add a few helper columns to table1

Add a helper column in table 1 called "Month" with the month formula feeding from the Sales date Column. =Month(

Add a helper column in table 1 called "Sales target" where you would put monthly target per name. (Considering that the sales target is fixed, if its variable by month/person, you would probably need a table with that info and then use a vlookup formula for 1 variable of a sumifs formula for 2 variables. Which formula would be dependent on the info contained in table 2 and the way it is displayed.

Add a helper column in Table 1 called "Target achieved" where you would calculate the sales amount for the person/per month using a "If"/ "Sumifs" combination formula where the display would be either “Achieved” ”Not achieved”

Then you would add the pivot with these new fields and select the ones you want to see. The pivot would work with data for 1 year only. For several years you would have to add the =year( dimension to it