Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Create or import a table with data values.
  2. Insert the Table filter macro and place the table within the macro.
  3. Configure the filtration parameters. For example, add filters by number range for the corresponding columns.
  4. Insert the Table chart macro.
  5. Place the Table filter macro with the table inside the Table chart macro.
  6. Configure parameters of the chart. For example, select the chart type as 'Column' and select the columns with row labels and data columns.
    Image Added
  7. Save the page.
  8. Enter the appropriate number range in the filter. Filtration will be automatically applied to the data table and the chart will be automatically updated.
  9. Change the Values column for another one, if needed.

...

  1. Create or import a table with data values.
  2. Insert the Table filter macro and place the table within the macro.
  3. Configure the filtration parameters. For example, add the filter by agent.
  4. Insert the Pivot table macro.
  5. Place the Table filter macro with the table inside the Pivot table macro.
  6. Configure parameters of the pivot table. For example, select the Agent column as row labels and the Earned Money for Support as the calculated column.
  7. Save the page.
  8. Enter Select the appropriate number range agents in the filter. Filtration will be automatically applied to the data table and the chart pivot table will be automatically updated.
  9. Change the Values calculated column for another one, if needed.

Image Added

Expand
titleClick to open the sample table...