I'm creating a Profit and Loss chart in Zoho Analytics using the Pivot Chart feature. While Net Profit can be calculated using the total value, I also need to calculate and display the Gross Profit/Loss directly within the chart.
To do this, I need to sum specific account types or columns and show the resulting Gross Profit/Loss as a subtotal or a calculated field within the Pivot Table itself. How can I achieve this in Zoho Analytics?