We designed a query, in which after drilling down on free char, the result is also calculated as the formula used above.
Please find the below screenshot for more understanding.
Total Amount column is a formula.
The result should display value as 50 not 90.
The need is to display the value as Summation of all above entries instead of calculating on the totals of the involved column in formula.
Please let me know how to achieve this.
NOTE: Points will be given once answered