Using the [Advanced Search] tool

[Advanced Search] uses pivot tables, a data summarization tool that can automatically sort, count, total or average the data stored, displaying the results in a second table showing the summarized data.

[Advanced Search for Products]

Data is displayed in metric tons of fertilizer products

Sources: AfricaFertilizer.org, FAOSTAT

[Advanced Search for Nutrients]

Data is displayed in metric tons of primary nutrients (N for Nitrogen, P2O5 for Phosphate, K2O for Potash)

Sources: AfricaFertilizer.org, FAOSTAT, IFADATA

Using filters

Users can use any combination of up to 3 filters: [Country], [Product], [Month].

By default, all data will be selected. Users can either select an item from the drop-down list or type the name of the [country] or the [product].

Once selection is done, applying the filters will generate a [result table] below the filters.

Generating and organizing result tables

Users can set up and change the summary’s structure by dragging and dropping fields graphically.

Move or swap any fields ([Country], [Fertilizer], [Type], [Unit], [Year], [Month]) to organize data in rows or columns according to your specific needs