11 Replies Latest reply: Aug 8, 2018 1:29 PM by Hamza Alsalman RSS

    add field to existing dimension

    Hamza Alsalman

      hello qlik community. I currently have a pivot table showing my three separate regions, Central Southern and Other. It shows the balances for each region and the account types for each region. What I would like to do is to add another dimension or measure called Total that would essentially sum all balances for each region and show me each account type's total balance. I understand there is a totals function, but I need it to display at the bottom. I also understand in the straight table it shows the totals on the bottom, however I also need partial totals for each region. Any help would be appreciated!