Use the GETPIVOTDATA function to get from the pivot table, the grand total of Profit for a Salesman