4 Replies Latest reply: Apr 14, 2013 4:35 PM by vsiqueira RSS

    Dynamic Table

      Folks, Please your help.

       

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

       

       

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