OBJECT

PivotTable

Pivot table of a report: summarizes records of one type by row and column dimensions, with its filter and view settings.

link GraphQL Schema definition

  • type PivotTable implements ReportStructureItem {
  • # Unique identifier of this item within the report structure.
  • id: ID!
  • # ID of a parent report structure, if ID is NULL this identifies root item, no
  • # more than one root item is allowed
  • parentId: ID
  • # Order of the item on the within same parent
  • sortOrder: Int!
  • # Entity type whose records the pivot reports on, such as Account, Lead or
  • # Opportunity.
  • entityType: EntityNameEnum!
  • # API name of the entity for this pivot; set for custom entities to identify which
  • # one is used.
  • entityApiName: String
  • # List of possible entity subtypes of entityType, if entity type is abstract you
  • # can supply with entityTypes of all children of abstract entity
  • entitySubtypes: [EntitySubtypeItem!]
  • # Id of the opportunity value field the pivot uses for amount calculations;
  • # applied only when the main box or pivot entity is Opportunity or LeadOppty.
  • calculationFieldId: ID
  • # Filter and view settings for the pivot report.
  • tabs: PivotReportTabsInterface!
  • }

link Require by

This element is not required by anyone