Mohon bantuannya saya ingin membuat report dengan php
database yang saya punya:

| klp_produk | barcode | jenis | klp_jenis | harga |
| Makanan | 1708000000000215410| Bakso | Basah | 10,000 |
| Makanan | 1708000000000215411| Nasi Goreng | Kering | 12,000 |
| Minuman | 1708000000000215412| Es Teh | Dingin | 4,000 |
| Minuman | 1708000000000215413| Teh Hangat | Hangat | 4,000 |
| Cemilan | 1708000000000215414| Keripik Ubi | Kering | 5,000 |


dari database diatas saya ingin membuat report tabel di php dengan format yang dihasilkan:
| | | Jumlah per Kelompok Produk | |
| | |
| Total |
|No. |Kelompok/Jenis| Makanan | Minuman | Cemilan | |
| | |
|
|
| | | Byk | Harga | Byk | Harga | Byk | Harga | Byk | Harga |
| A | Basah |
| |
| 1 | Bakso | 1 | 10,000| | | | | 1 | 10,000 |
|Sub Total Basah | 1 | 10,000| | | | | 1 | 10,000 |
| B | Kering |
| |
| 1 | Nasi Goreng | 1 | 12,000| | | | | 1 | 12,000 |
| 2 | Keripik Ubi | | | | | 1 | 5,000 | 1 | 5,000 |
| Sub Total Kering | 1 | 12,000| | | 1 | 5,000 | 2 | 17,000 |
| C | Dingin |
| |
| 1 | Es Teh | | | 1 | 4,000| | | 1 | 4,000 |
| Sub Total Dingin | | | 1 | 4,000| | | 1 | 4,000 |
| D | Hangat |
| |
| 1 | Teh Hangat | | | 1 | 4,000| | | 1 | 4,000 |
| Sub Total Hangat | | | 1 | 4,000| | | 1 | 4,000 |
| Grand Total | 2 | 22,000| 2 | 8,000| | | 5 | 35,000 |

Demikian, tks
Silahkan login untuk menjawab!