Combining straight tables

[sifatnabil]

Hi all,

I have the below 5 similar straight tables with different dimensions but exact same expressions, but I want to combine them. This is because it's a hassle to maintain and do column sorts (need to sort column 5 times for example). Is this possible in Qlikview?

[sunny_talwar]

So within each dimension, you want it to be sorted by numerically descending order?

[sifatnabil]

Yes.

[sunny_talwar]

Sort using this

=RangeSum(Dim, -Sum(Revenue)/1E10)

[sifatnabil]

Amazing!