Hi,
I have a data set like below and need to create a subtotal of the sections. I cant use the sum if function as the table will be filtered and need the section subtotals to be dynamic in line with the table filter.
The filters are setup for BRAND,REGION,AREA and SITE. The idea is I have a separate chart which subtotals as the user applies filters
Any help please?
Thanks in Advance
<tbody>
</tbody>
I have a data set like below and need to create a subtotal of the sections. I cant use the sum if function as the table will be filtered and need the section subtotals to be dynamic in line with the table filter.
The filters are setup for BRAND,REGION,AREA and SITE. The idea is I have a separate chart which subtotals as the user applies filters
Any help please?
Thanks in Advance
Col A | Col B | Col C | Col D | Col E | Col F | Col G | Col H |
BRAND | REGION | AREA | SITE | SITE NO | SECTION NAME | RC 1 RESULTS | RC 2 RESULTS |
client 1 | North | Taz | Beds | 01 | CASH | 80% | 91% |
client 1 | North | Taz | Beds | 01 | REVENUE | 95% | 82% |
client 1 | North | Taz | HULL | 02 | CASH | 81% | 83% |
client 1 | North | Taz | HULL | 02 | REVENUE | 58% | 94% |
client 1 | US | BILL | NY | 03 | CASH | 60% | 99% |
client 1 | US | BILL | NY | 03 | REVENUE | 78% |
<tbody>
</tbody>