Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Table

Folks, please your help.

I'll have to create the following dynamic table

BRANDMODELMTD% SHAREVAR. m-1VAR. 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 ?

1 Reply
Not applicable
Author

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