How do you know the Department A and B belongs to Division 1? Is there any link in database?

Hi,

I am sorry for my late reply. Your case is quite difficulty for koolphp/Table to display since data is from different sources and mixing to one table like above is difficult. The solution could be that you create your own tables. First echo date row with total quantity. Second, loop though all the division data from query 2. For each division, you first echo the division data, then you need to search the data from query 2 for departments which link to that division, you also echo the row with department name and quantiy.

We have show you how to get the raw data from dataStore(), don't we?

$rows = $this->dataStore("store_of_query2")->data();
foreach($rows as $row)
{
    echo $row["name"]." ".$row["quantity"];
}