Editing Number and Date Fields

Number fields in the Pivot Chart can be edited and configured to display numbers how you want.

To configure a number field:

1. Next to a number field, click the Edit icon.
2. Select options to configure the field:

   • Field display name - Enter a name for the field.

   • Use short notation K/M/B (1,000 -> 1K)- Select the abreviation you want to use.

     • K for 1,000s
     • M for 1,000,000s
     • B for 1,000,000,000s

   • Decimal places - Select the number of digits you want after the decimal.

   • Format - Select the number format. Numbers can be presented without formatting, as a percentage, with a currency sign, or with a currency code.

   • Value range - Set minimum and maximum values. Only values that fall within the range are displayed.

     

To configure a date field:

1. Next to a date field, click the Edit icon.
2. Select options to configure the field:
   • Field display name - Enter a name for the field.
   • Aggregation - Select an aggregation time frame.
   • Format - Select the date format you want.