Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Im adding 2 files, one with some sample data and an image with the expected results. Thanks for the help