Element Fixing
Making an index an outer index will reduce the dimension of the pivot table. Another way of reducing the size of the pivot table is to fix one or more indices. To fix an index to a certain value you should
switch to ‘fixing’ mode by pressing the filter button
in front of the row or column area,
check the elements you want to restrict to by pressing the checkboxes
in front of these element, and
switch back to ‘normal’ mode by pressing the filter button
once again.
Once a certain index has been fixed to a specific value, this fixed element will be equipped with a ‘drop-down’ button . When you press this button a drop-down list appears that allows you to fix the index to some other element.