16 Replies Latest reply: Aug 31, 2012 3:49 PM by Sebastian Pereira RSS

    creation of a column with the accumulated

      Hello:

       

      I have a problem about the creation of a column with the accumulated value when the table has more than one dimension (I'm not sure if this will be a hindrance).

       

      I want to create a new column with the cumulative sales, called %VENTAS ACUM, whose expression % is (Sum (VALOR_NETO_MOV) / Sum (TOTAL VALOR_NETO_MOV)), the problem is that when I want to create this column selecting "full accumulation" is not generated and it shows the same as the column %VENTAS, that it has the same expression without "full acumulation". In this table I have 2 dimenssions,

       

      Now I found that when using only one dimension that I have on my my table, the results of %VENTAS and %VENTAS ACUM are correct.

       

      I tried with the formula IF(Rowno () = 1, [% row] [% row] + above ([% Cumulative row.])), but the results of %VENTA and %VENTAS ACUM are the same too,

       

       

      HELP ME PLEASE!!