Making a Dynamic Subtotal

An Excel file that teaches how to perform Making a Dynamic Subtotal operation.

Excel Dashboard for Making A Dynamic Subtotal

Groups are defined. Subtotals are calculated using formulas. Values are updated when filters are changed. Table layout is preserved. The results report is generated automatically.

Hope it is useful.