Use relative cell references

You can address these cells directly. In a calculation you can refer to a specific cell in the spreadsheet and use its content.

Prerequisite

A table view is created for the query or the ad-hoc analysis.

Procedure

  1. Start the query or the ad-hoc analysis.
  2. Click Output Output if the table is hidden.
  3. Enter the relevant formula, for example, SUM.

    Cell references 1

  4. Copy these cells and paste them at another position in the spreadsheet.

    The references in the formula have changed:

    Cell references 2

You have inserted relative cell references. If you insert the calculation cell at another position, the calculation is performed for the new area, as well.