PHP ADOdb: Understanding Pivot Table For Reporting

PHP ADOdb Reporting Tutorial: We use pivot table especially for reports, example marketing reports. Pivot table that summarizes and analyzes data. If you don't understand about pivot table, this post will show you visually what is pivot table.

For example you have two reference table, like this:

products table

cities table

Then, you have a sales data like this:

We can create sales report like product sales frequency per city, like this:

This report, We call pivot table or cross tabulation

Next post, we will talk about creating pivot table use adodb.