I don't think I caught the issues at hand.
I did however notice that those Countries with a null for [Decades Degree Diff] are showing up as being in the bottom of the list.
I forced the nulls out of the bottom list with
IF ISNULL([Decades Degree Diff]) THEN 1000
ELSE [Decades Degree Diff]
Then created a new bottom set with that,
and then created a new joined set.
Please see sheet11 of the attached.
I'm not sure if that addresses the issues you are seeing.
255481temp.twbx 17.4 MB
Hey Swaroop - thanks for identifying the issue (Null values) that messed up the top/bottom N values. This fixed it.
the only issue I'm having now is the "bottom n" values not being labeled as bottom n. They are all included as top n.
Any ideas what I'm missing? thanks.
Screenshot (there's clearly a bottom 5 here, but there all labeled top/in):
You could try a conditional calculation that takes into account Set in/out like this:
IF [Top - Degrees Diff] THEN "Top "+STR([Top/Bottom N])
ELSEIF [Bottom - Degrees Diff (copy 2)] THEN "Bottom "+STR([Top/Bottom N])
Please see Sheet13 of the attached.
255481temp2.twbx 17.2 MB