The bottom right square is the total sales amount of 6.4 million which is what I expect to see here.īy default, the values in the data grid are totals, but this can be changed by right-clicking in the grid to open the Pivot Table Field dialog box.
CREATE TABULAR DATABASE WITH PIVOT CODE
Notice that you can see a subtotal for each payment type in the far right column, and the totals for each product code along the bottom. Since I want to see the sales totals, click the amount and drop it in the middle where it says Drop Data Items Here. Next, click Product Code, and drag it to where it says Drop Column Fields here. The creation of a pivot table in IDEA is graphic, so all you need to do is select the field you want from the field list box and drag it to the appropriate location on the pivot table. Start by clicking Pay Type and dragging it to the row header where it says Drop Row Fields Here. I’m calling mine Sales Transactions Pivot Table. The first thing you will be asked is to provide a name. On the Analysis tab, in the Categorize group, select Pivot Table. Start by opening your source file, which is the Sales Transactions database. In this example, I’m going to create a table showing the different payment types used for each product code as well as the sales totals. A pivot table is another means of profiling data in a tabular format.
0 kommentar(er)
