I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...
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 ...