0 Replies Latest reply: Apr 8, 2013 12:18 PM by b8400bve RSS

    subtotal sum for multiple dimensions

      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 ?