Hi, I am wondering if it's possible to customize the total mode calculation to something other than the functions that the total mode in chart properties provide.
I am hoping to produce a simple straight table with a calculated row on the bottom. The calculation would add/subtract different line items to get the desired result.
The dimension for the table is "Report_Items" and some line items include: Revenue, Direct Expense, Indirect Expense. To make this example simple, I just want the bottom row to calculate Profitability as Revenue minus Direct Expense minus Indirect Expense.
Any suggestion to the total mode customization or other approaches?
