I have below Sample data from database to show as pivot with subtotal on each group
| Balance Type | Service Type | Dvision | OU | Balance |
|---|
| Past Due | Service 1 | Division 1 | Ou 1 | 10 |
| Past Due | Service 1 | Division 1 | Ou 2 | 20 |
| Past Due | Service 2 | Division 1 | Ou 1 | 30 |
| Past Due | Service 2 | Division 2 | Ou 2 | 40 |
| Current | Service 1 | Division 1 | Ou 1 | 50 |
| Current | Service 2 | Division 1 | Ou 2 | 60 |
| Current | Service 2 | Division 2 | Ou 1 | 70 |
| Current | Service 2 | Division 2 | Ou 2 | 70 |
Expected Output in PLSQL Dynamic Content
| Service 1 | Service 1 Total | Service 2 | Service 2 Total | Grand Total |
| Division 1 | Division 1 Total | | Division 1 | Division 1 Total | Division 2 | Division 2 Total | | |
|---|
| Balance Type | Ou1 | Ou2 | | | Ou1 | Ou2 | | Ou1 | Ou2 | | | |
| Current | 50 | | 50 | 50 | | 60 | 60 | 70 | 70 | 140 | 200 | 250 |
| Past Due | 10 | 20 | 30 | 30 | 30 | | 30 | | 40 | 40 | 70 | 100 |
| Grand Total | 60 | 20 | 80 | 80 | 30 | 60 | 90 | 70 | 110 | 180 | 270 | 350 |
I want to create PLsql Dynamic Content to display a html report using htp.p with css or javascript . Also if possible i want some collapsible groups at each level.