Discussion Board for collaboration related to Creating Analytics for QlikView.
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 ?