HowTo:Pivot Tables: Difference between revisions
Created page with "Add content from Pivot Table.docx document located in: Epiphany Wiki > Add to Wiki folder on share drive." |
No edit summary |
||
| Line 1: | Line 1: | ||
== Pivot Tables in Pirouette == | |||
Pivot Tables can be created in the Pirouette. The point of a Pivot Table is to sum things. A Pivot Table can only have one Column. To set the Pivot criteria using a date field you must first drag the field into the Rows area, select the option from the drop-down, then drag the button to the Pivot section. | |||
First Step in using the Pirouette is to create the Definition. The Main Object must be the lowest level the data comes from. For Example: Analyzing Expense Accounts on an AP Invoice is taken from the AP Invoice Lines rather than the Invoice itself because the GL accounts are attached at the AP Invoice Line level. | |||
Add the desired Properties to the Pivot Table Properties area. The Property names can be found on the Main Table by displaying Help. | |||
If you want to expand on the above by adding in Vendor Name, you need to add in a related object because it is on the AP Invoice rather than the AP Invoice Line. To do this you manually add the related object from Relationships to the specific line detail of the Pivot Table Properties (to get to the line detail of Vendor, double-click on the blue square at left of Vendor line). | |||
Revision as of 17:46, 15 April 2020
Pivot Tables in Pirouette
Pivot Tables can be created in the Pirouette. The point of a Pivot Table is to sum things. A Pivot Table can only have one Column. To set the Pivot criteria using a date field you must first drag the field into the Rows area, select the option from the drop-down, then drag the button to the Pivot section.
First Step in using the Pirouette is to create the Definition. The Main Object must be the lowest level the data comes from. For Example: Analyzing Expense Accounts on an AP Invoice is taken from the AP Invoice Lines rather than the Invoice itself because the GL accounts are attached at the AP Invoice Line level.
Add the desired Properties to the Pivot Table Properties area. The Property names can be found on the Main Table by displaying Help.
If you want to expand on the above by adding in Vendor Name, you need to add in a related object because it is on the AP Invoice rather than the AP Invoice Line. To do this you manually add the related object from Relationships to the specific line detail of the Pivot Table Properties (to get to the line detail of Vendor, double-click on the blue square at left of Vendor line).
