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:25] cds4byu |
help-wiki:making_a_pivot_table [2023/09/01 09:54] (current) cds4byu |
||
|---|---|---|---|
| Line 11: | Line 11: | ||
| -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.{{ : | ||
help-wiki/making_a_pivot_table.1693502705.txt.gz ยท Last modified: 2023/08/31 11:25 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
