Managing table columns

After you bring your data into PowerPivot you can manage the data within both…the PowerPivot datasheet and also within your PivotTables.…In this movie I will show you how to work with PowerPivot columns of data.…So to display the data that I have in this worksheet, I will click the…PowerPivot tab and then open the PowerPivot window by clicking the PowerPivot…Window button in the Launch section of this tab on the Ribbon, and when I do my…data appears in PowerPivot, and to indicate how much data we're working with,…at the bottom left corner you can see that we are currently looking at Row 1 of 964,260.…

In PowerPivot as in Excel you can manipulate the columns inside of…the PowerPivot window.…So let's say for example that you want to hide a particular column and in…this case we will just say that we want to hide the Product column, to do…that you can right-click the column header and then click Hide Columns and…then select whether you want to hide the column from the PowerPivot window…and the PivotTable,…