Reorder Calculations in Pigment

  • 12 June 2024
  • 0 replies
  • 165 views

Userlevel 4
Badge +3

You can view and reorder the order of calculations within a Table or Metric in the Calculations tab in the Configuration Data pane.

To view the current order of your Calculated Items, do one of the following:

  • Click Pivot, and in the Configure Data panel click Calculations.
  • Click the arrow on a Calculated Item header, and select Define calculations priority from the menu.
  • Right-click a Calculated Item cell value, and select Define calculations priority from the menu.

Now that you’ve opened the Calculations tab, let’s understand the default display order of your list of Calculated Items:

  • Calculated Items in rows are performed before Calculated Items in columns.
  • In the same axis, calculations for outer Dimension Calculated Items are performed before those for inner Dimension Calculated Items.
  • Within the same row or column, your Calculated Items are performed alphabetically.

If you make no changes in the Calculations tab, Pigment uses the default order described above. Any change made in the Pivot tab will also be reflected in the Calculations tab.

To reorder your current sequence of calculations, you drag and drop each Calculated Item to the required position in the list. The order in which you reorder your Calculated Items affects the order in which they are calculated. Take a look:

  1. The calculation located at the end of the list is performed first.
  2. The calculation immediately above it is performed next.
  3. The sequence of calculations continues to the calculation at the top of the list, which is performed last.
Reordering Calculated Items

If you make changes in the Calculations tab, then these changes will define the new order of your Calculated Items, and the Reset to default priority button is displayed. Any change made in the Pivot tab won’t be reflected in the Calculations tab until the calculations priority are not reset to their default order. If at any point you want to restore your list of calculation to default order, you can click Reset to default priority.

For more information on calculations in Pigment, see:

 


0 replies

Be the first to reply!

Reply