hello
my raw data is in two tables
table1: name, sales_amount, Sales_date
table2: name, sales_target

i have imported table1 data in pivot table as -
name in row, date in column and sales_amt in sum_total

my problem is that i want to find out that on which date/month each sales_man exceeded his/her target.

Is it possible in excel.

TIA