I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...
To apply the dollar currency to a value, select the cell, press Ctrl+1 to launch the Format Cells dialog box, and select "Currency" or "Accounting" in the Number tab. Then, choose the dollar symbol ...
I asked Google Gemini to work on my mutual funds to see if it could outperform my advisor. The results will surprise you.