How is the calculation performed?

• The content of the Pivot Table control must be entirely recalculated:
  • When adding new items to display.
  • When modifying the filtering functions.
  • When modifying the source data of calculation.
• The content of the Pivot Table control does not need to be entirely recalculated:
  • When using a filter on a dimension that is already calculated.
  • When changing dimension.
  • When expanding or collapsing a dimension (to view the trimesters instead of the years for example).

Progress of calculation

• A progress bar is displayed during the calculation of the Pivot Table control.
• Versions 20 and later
  The user has the ability to cancel the calculation via a "Cancel" button.

  

  To find out whether the calculation was entirely performed, use the ErrorOccurred variable.
  Example:
  

  PROCEDURE Load_PVT()
   
  PVTCalculateAll(PVT_Statistics)
  IF ErrorOccurred = True THEN
  SWITCH Dialog("Do you want to cancel the current process?")
  // Cancel
  CASE 1
  Close()
  // Continue
  CASE 0
  Load_PVT()
  END
  END
  
  New in version 20
  The user has the ability to cancel the calculation via a "Cancel" button.

  

  To find out whether the calculation was entirely performed, use the ErrorOccurred variable.
  Example:
  

  PROCEDURE Load_PVT()
   
  PVTCalculateAll(PVT_Statistics)
  IF ErrorOccurred = True THEN
  SWITCH Dialog("Do you want to cancel the current process?")
  // Cancel
  CASE 1
  Close()
  // Continue
  CASE 0
  Load_PVT()
  END
  END
  
  The user has the ability to cancel the calculation via a "Cancel" button.
  
  To find out whether the calculation was entirely performed, use the ErrorOccurred variable.
  Example:
  
  PROCEDURE Load_PVT()
   
  PVTCalculateAll(PVT_Statistics)
  IF ErrorOccurred = True THEN
  SWITCH Dialog("Do you want to cancel the current process?")
  // Cancel
  CASE 1
  Close()
  // Continue
  CASE 0
  Load_PVT()
  END
  END