Here is one way to address it using a simple Table Calc of:
To do this, I created a combined field of Salesman+Product, so I could compute the Table Calculation across this new dimension.
I placed that in the view, between Date and Saleman on the Rows shelf, then right clicked on the pill and de-selected "Show Header", so this column is not shown in the view, but I can use it in the Table Calculation's compute using settings.
Then, I placed the LAST field on the filter shelf, set it to a range of 0 to 0 (keep only the first row in the partition), then set up the partitioning in the Table Calculation > Compute Using > Advanced dialog as follows (click to enlarge)
Version 8.1 workbook attached. Let me know if you have questions. If you want to use this method in your workbook, you may have to change the settings/set up of your view, because Table Calculations compute based on the dimensions in your view--if you have more dimensions, the advanced settings will look a bit different. But for the scenario you posted, this solution works very well.
Thank you so much!
No problem! Were you able to resolve your issue? Please don't forget to mark the question answered in some way if you have resolved the problem. Cheers!