Calculated Add(String, String, Object, Object) Members.
Add(String, String, Object, Object)
Adds a calculated field or calculated item to a PivotTable.
public Microsoft.Office.Interop.Excel.CalculatedMember Add (string Name, string Formula, object SolveOrder, object Type);
Public Function Add (Name As String, Formula As String, Optional SolveOrder As Object, Optional Type As Object) As CalculatedMember
Formula argument must have a valid MDX (multidimensional expression) syntax statement. The
Name argument has to be acceptable to the Online Analytical Processing (OLAP) provider and the
Type argument has to be defined.
If you set the
Type argument of this method to
xlCalculatedSet, then you must call the AddSet(String, String) method to make the new field set visible in the PivotTable.