Dynamic Table

[#1]

Folks, Please your help.

I'm trying to create the following Dynamic Table, but having a lot of difficulties with the expressions:

BRAND

MODEL

MTD

%

SHARE

VAR. m-1

VAR. m-12

Brand: List of all brands

Model: sub group of all models within the brands (User can expand or collapse)

MTD: Number of registers Month to Date (Number of sales in the current period)

%: Percentage that each model represents within the brand (Number of sales of each model / number of sales of the brand)

Share: Percentage that each model represents within the total (All Brands and Models).

Could anyone help me build this table ?

Thanks in advance!

[#2]

hi

vsiqueira

give me a sample data

[nilesh_gangurde]

it can be done...

please provide the sample data..

-Nilesh

[#4]

Great Gernan. Thanks for the help!

I included 2 files on the post, with sample data and expected result, so we can proceed.

[#5]

Very Nice Nilesh. Thanks for the help!

I included 2 files on the original post, with sample data and expected result, so we can proceed.