I am trying to insert Field component to show the Total Sales amount as shown in the screenshot below. However, the field function only allows me to show ‘Total’ as only option which is the content of the first row of column 10, while I want the actual number ($29,871) which is the second row of column 10 to be the content of field component. How should I solve this technical issue?
T8rjP8dTo7Qfyj5BjMOLeGUBB.png)