Dynamic Table

[#1]

Folks, please your help.

I'll have to create the following dynamic table

BRAND	MODEL	MTD	%	SHARE	VAR. m-1	VAR. m-12

Brand: Group of brands

Model: List of each model within the Brand group (User can expand or collapse)

MTD: Number of registers (month to date) - Count in current month

% : The percentage that each model represent in the group ( Model / Group Total)

Share: The percentage that each model represent within the total (brands and models)

Could Anyone please help me ? How can I calculate this ?

[#2]

Im adding 2 files, one with some sample data and an image with the expected results. Thanks for the help