Using the Drilldown Engine

In this section we will explore how to classify, organise, filter, summarise, and analyse your data with the Drilldown Engine (DE).

The examples used are based on the stocklist of a small bookshop. All files referred to can be found in the ???/BOOKSHOP folder.

Make sure that the Drilldown Engine is turned off and open Bookshop#book.CSV.

Now work your way through the following topics.


The Drilldown Engine (DE) brings together data reporting, classifying, summarising, and filtering functions within a single facility.

The DE combines the power of complex queries with a highly interactive interface. Data can be re-organised at will with results being displayed instantly.

DE builds complex SQL queries in the background without the need for any knowledge of SQL.