Excellent explanation. Would you mind sharing how to display all of the column data while excluding one particular column value? say, by showing the combined sales of every nation excluding China.
All I can think of is P() and E() function... below is the expression i have used but not sure what is the issue.
sum ( {$<country =- p({$<country={'China'}>} country)>} Sales)