I have a basic cross tab counting people by their location: 50 people in England; 20 People in Scotland and 3 People in Wales.
When I apply a custom sort, Wales - England - Scotland, some totals display 0.
What I should mention is that the people count is a variable using functions: if, then, else.
I should also mention that I am using XI3.1 and the custom sort needs to be applied to a document with merged dimensions (2 different queries)
As it has been some while since I’ve created reports, deja vu has me completely because I remember having this issue before but cannot remember how I solved it. .Any ideas?
Decisys 
(BOB member since 2004-05-21)