How to calculate the total sum of a field in beast Mode
How can I calculate the total sum for a given row based on the condition. e.g.
for every G_Account No. I will like to calculate total Amount, for Transaction = 0 and Transaction = 1 aggregated by year:
I have used the formulala:
sum(sum(`Amount`)) over (partition by year(`Posting Date`)), however it correctly calculates for the year, but sums up both for Transaction 1 & 0.