Facts set within a pivot section. These are columns added to the facts groups in the outliner.
All collections have a method named “Item(NameOrIndex).” This is the default method for all collections and it returns an item in the collection at a particular index or with a specific name. Use brackets ([]) to represent calls to the Item (Method). For example, these statements are identical: myItem = Documents[1] myItem = Documents.Item(1) myItem = Documents["StartUp.bqy"] myItem = Documents.Item("StartUp.bqy") |
This example shows how to add request items to facts collections:
ActiveDocument.Sections["Pivot"].Facts.RemoveAll() ActiveDocument.Sections["Pivot"].Facts.Add("Year") ActiveDocument.Sections["Pivot"].Facts.Add("Region")
Add(RequestItemName As String, [optional] Index as Number) As PivotFact, AddComputedItem(Name As String Expression as String, [optional] Number As Index) As PivotFact, Item(Value as NameOrIndex) As PivotFact, RemoveAll()