User Tools
help-wiki:making_a_pivot_table
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
help-wiki:making_a_pivot_table [2023/08/31 11:13] cds4byu |
help-wiki:making_a_pivot_table [2023/09/01 09:54] (current) cds4byu |
||
|---|---|---|---|
| Line 10: | Line 10: | ||
| -If the data to be placed in the Values area is numeric, click on the name of the field and drag it to the Values window. | -If the data to be placed in the Values area is numeric, click on the name of the field and drag it to the Values window. | ||
| -If the data to be placed in the Values area is text (like NetID), you will need to create a new Measure for that data, as follows: | -If the data to be placed in the Values area is text (like NetID), you will need to create a new Measure for that data, as follows: | ||
| - | -Right-click on Table 1 in the field list, and select Add Measure | + | -Right-click on Table 1 in the field list, and select Add Measure{{ : |
| - | -When the Measure window pops up, type in a measure name (List of NetIDs in this example; you can make it be whatever you want). | + | -When the Measure window pops up, type in a measure name (List of NetIDs in this example; you can make it be whatever you want). |
| -Click OK on the Measure window | -Click OK on the Measure window | ||
| - | -Now, go to the Pivot Table Fields list, and you should have a new field to choose from. Select the checkbox for the field, and it will go into the Values area. | + | -Now, go to the Pivot Table Fields list, and you should have a new field to choose from. Select the checkbox for the field, and it will go into the Values area.{{ : |
| - | -Turn off the row and column totals by selecting Pivot Table, Options, then the Totals & Filters tab, and clearing the Show grand totals for rows and Show grand totals for columns checkboxes. | + | -Turn off the row and column totals by selecting Pivot Table, Options, then the Totals & Filters tab, and clearing the Show grand totals for rows and Show grand totals for columns checkboxes. |
| That should do it. You now have a pivot table. | That should do it. You now have a pivot table. | ||
help-wiki/making_a_pivot_table.1693501996.txt.gz · Last modified: 2023/08/31 11:13 by cds4byu
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: Copyright Brigham Young University, all rights reserved
