When creating calculations on a chart, in some situations, you may want to reference a value of a previous record in the chart, or reference a column in a table chart with a predefined expression. We can use an inter-record function to help us with this requirement.
These are the inter-record functions we will learn:
- Above()
- Column()
Before starting the examples, we will create a new sheet with the name Inter-Record. The following steps will help us to create and use a new sheet:
- Open the app and click on Create new sheet
- Set the title of the sheet to Inter-Record
- Click on the sheet icon to save the title, and then open the sheet to start creating