Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
hamza99a
Creator II
Creator II

add field to existing dimension

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!

12 Replies
sunny_talwar

I have attached the qvf for you to review... please check it and see if it make sense

hamza99a
Creator II
Creator II
Author

Thank you so much for your help!

Kejti
Partner - Contributor II
Partner - Contributor II

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!!