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
Start the query or the ad-hoc analysis.
Click Output if the table is hidden.
Enter the relevant formula in the table, for example, SUM. Enter a dollar sign in front of both the column and the row:
Copy these cells and paste them at another position in the spreadsheet.
The references in the formula have not changed:
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.