Hello,
I tried to search for this but had no luck. Could be just an issue with knowing what to search for. If so I apologise, can you point me to the correct place.
I am trying to produce a (dynamic) list of the Top 5 Categories with their Top 5 Sub-categories and the remainder Categories/Sub-categories are summated. Data is presentated in 3 colums; Category, Sub-Category & Total. So the amount that determines the order is at the Sub-Category level & will need to be summed by Category to determing the order. This is where I came undone. I could work a way to just get the Top of a single dimension list & sum the remainder. But the 2nd dimension throwes me.
As an example for a Top 3 of Top 3 set. If the data was this:
<tbody>
</tbody><colgroup><col><col><col></colgroup>
Then the result would be like this:
<tbody>
</tbody><colgroup><col span="2"><col></colgroup>
Cheers & thanks for any assistance.
I tried to search for this but had no luck. Could be just an issue with knowing what to search for. If so I apologise, can you point me to the correct place.
I am trying to produce a (dynamic) list of the Top 5 Categories with their Top 5 Sub-categories and the remainder Categories/Sub-categories are summated. Data is presentated in 3 colums; Category, Sub-Category & Total. So the amount that determines the order is at the Sub-Category level & will need to be summed by Category to determing the order. This is where I came undone. I could work a way to just get the Top of a single dimension list & sum the remainder. But the 2nd dimension throwes me.
As an example for a Top 3 of Top 3 set. If the data was this:
| Category | Sub-Category | Total |
| Field Activity | Service Order/Work Order | 12 |
| Field Activity | Access/Gates | 11 |
| Field Activity | Staff Conduct | 16 |
| Field Activity | Damage to Property | 18 |
| Field Activity | Incomplete Work | 12 |
| Infrastructure | Other | 20 |
| Infrastructure | Poles | 6 |
| Infrastructure | Substation | 6 |
| Infrastructure | Advertising/Painting-EE Asset | 1 |
| Infrastructure | Line Clearance | 3 |
| Infrastructure | Turret/Pillar Box | 3 |
| Quality of Supply | Outage Notification | 42 |
| Quality of Supply | Not Notified of Results | 17 |
| Quality of Supply | Outage Duration | 12 |
| NMI Reclassification Distribution | Information Notice | 1 |
| Meter Reading | Estimates | 35 |
| Meter Reading | Access | 47 |
| Meter Reading | Staff Conduct | 12 |
| Meter Reading | Gates | 14 |
| Meter Reading | Qld Locksmiths | 2 |
| Meter Reading | Date/Time | 2 |
| Advertising/Marketing | General | 1 |
<tbody>
</tbody><colgroup><col><col><col></colgroup>
Then the result would be like this:
| Category | Sub-Category | Total |
| Meter Reading | 112 | |
| Meter Reading | Estimates | 35 |
| Meter Reading | Access | 47 |
| Meter Reading | Gates | 14 |
| Meter Reading | All Other Sub-categories | 16 |
| Quality of Supply | 71 | |
| Quality of Supply | Outage Notification | 42 |
| Quality of Supply | Not Notified of Results | 17 |
| Quality of Supply | Outage Duration | 12 |
| Field Activity | 69 | |
| Field Activity | Damage to Property | 18 |
| Field Activity | Staff Conduct | 16 |
| Field Activity | Incomplete Work | 12 |
| Field Activity | All Other Sub-categories | 23 |
| All Other Categories | 41 | |
| All Other Categories | Other | 20 |
| All Other Categories | Poles | 6 |
| All Other Categories | Substation | 6 |
| All Other Categories | All Other Sub-categories | 9 |
| TOTAL | 586 |
<tbody>
</tbody><colgroup><col span="2"><col></colgroup>
Cheers & thanks for any assistance.
