Thanks for your quick reply. I tried it, and only the first half works. I managed to get all the records to sort according to their sum in each pane.
However, when I get to step 10 of the setting up custom filter part, instead of giving me 1,2,3,4,5,6 on the running sum of minimum number of records, it gives 1,1,1,1,1,1 throughout. How come?
I'd have to see your workbook, but my guess is you need to change how the table calculation is being computed. Right click on the calculation and select Compute Using--> then Pane (Down)---depending how your view is set up this might be different. If this doesn't work, maybe you can post your workbook (twbx file)? Hope this helps!
Ok found the problem. The reason was because on step of creating the set, i duplicated the two dimensions instead of duplicating only the higher level one. Thus using the duplicated fields as the set.
Not sure whats the logic behind this is, but thats the reason.