HowTo:Pivot Tables: Difference between revisions
No edit summary |
No edit summary |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 18: | Line 18: | ||
:*Detail ID: | :*Detail ID: | ||
[[File:Pivot_Tables_Properties.png]] | [[File:Pivot_Tables_Properties.png]] | ||
Creating a Pivot Table | |||
:*Select a Pivot Table from the left pane | |||
:*Click Fields | |||
:*Drag and Drop the fields into the desired Build Area (Rows, Columns, Filters, Pivot). | |||
:*Click Rebuild to see the results | |||
:*Save the table as a Preset | |||
[[File:Pivot_Tables_Tables.png]] | |||
[[File:Pivot_Tables_Fields.png]] | |||
Helpful Hints: | |||
:*Start with a small amount of data while building the table | |||
:*Prove out the data to verify the build is correct | |||
:*Save Preset (give it a meaningful name) | |||
:*Continue to add fields, test, and verify build is correct | |||
:*Save (overwrites the current Preset) | |||
:*To Save as a new Preset, preserving your current Preset, typeover the name with a meaningful name of the new preset and save | |||
:*Drill down into data by double-clicking on a field in the results area | |||