I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...
MUO on MSN
I replaced Excel's PivotTables with this extremely overpowered tool and haven’t looked back
To activate Power Pivot, go to File > Options, click Add-ins, select COM Add-ins from the dropdown, and check the box for Microsoft Power Pivot for Excel. Once enabled, a new Power Pivot tab appears ...
Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and columns of ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results