Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community
I'm stuck with subtotals
I attached file for example
I want a daily cash position for all our bank accounts
Therefore I took the last statement nr per bank account and found the corresponding amount (through firstsortedvalue)
However, I don't succeed in subtotaling the amounts per currency or per company
I took statement nr and amount as expressions and company, curreny and bank account nr as dimension
Any idea how to solve ?