Use fixed 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.

Procedure

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 in the table, for example, SUM. Enter a dollar sign in front of both the column and the row:

    Cell references 1

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

    The references in the formula have not changed:

    Cell references 2

    You can also enter the dollar sign only in front of the column or only in front of the row in order to save only the column or the row.

You have inserted fixed cell references. If you insert the calculation cell at another position, the calculation of the original area is retained.