Pivot¶

At the moment we can produce the cross-tab interface from the straight data table back from KDW Data. However, the spreadsheet itself is not very useful for analysis because it is difficult to filter out the relevant data we may require, or to cut it down to a particular request. Therefore with the Pivot table you can restructure the data anyway you would like.

Figure 23. Pivot table on a Refreshable Nutrition Workbook

For example you can filter the data by Admin unit as it is shown in Figure 34, or you can take particular indicator groups to push them down or back up again.