Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I have attached the qvf for you to review... please check it and see if it make sense
Thank you so much for your help!
Hi @sunny_talwar , do you know how to add the new dimension to the existing one, but with the specific expression for this new dimension?
E.G. based on the data above - to add the dimension NEW, that will show the value : SUM(OTHER + SOUTH)
Thanks in advance!!