This is a very simple example of using set analysis. First, we load data to use for playing.

playdata:
LOAD * Inline [
ID , name, children
1, Joe S, 3
2, Don B, 3
3, Joe C, 0
4, Don D, 4
5, Glenda S, 3
6, Mary B, 3
7, Helena C, 0
8, Ellen D, 4
];

Next we add a very simple sheet. The top left corner totals all the children in the data. The bottom left corner is a simple table that displays all the rows. The top right portion totals all the children that belong to ‘Don B’. The bottom right totals all the children that do not belong to ‘Don B’.

The titles are displaying the actual set statement required. The top one is summing all children belonging to ‘Don B’. The one below it is summing all children that do NOT belong to ‘Don B’.