5 Replies Latest reply: Feb 7, 2014 11:11 AM by Bérengère BOILEAU RSS

    Add expression in a table

      Hello everybody,

      I have a simple table with one dimension (Company) and several expressions (turnover, costs_1, costs_2….)

      My table is like this :

      Company            Turnover             Costs_1                   Costs_2                 Costs_3                     …

      Toto                      3000                      300                        200                        100                                                       

      Titi                        2000                      200                        250                        150

      Tutu                      1000                       80                         260                        180        

      Tata                       800                       100                        130                        150

      Tete                       700                       120                        100                        100

      Toutou                   500                        100                         80                         60

      …                           …                        …                            …                         …                            …

       

      This table contains 30 companies and I  would like to add lines “top 3” and “top 5” under the company which has rank 3 and under the company which has rank 5 (the criteria for rank is turnover).

      I know the expression I want but if I add it as “expression”, I have a new column in my table and it’s not that I want. I need that “top 3” and “top 5” appear as lines, not as column, like this :

       

      Company            Turnover             Costs_1                 Costs_2                   Costs_3                 …

      Toto                      3000                      300                        200                        100                                                       

      Titi                        2000                      200                        250                        150

      Tutu                      1000                      80                          260                        180        

      Top 3                    6000                      580                        710                        430

      Tata                       800                       100                        130                        150

      Tete                       700                       120                        100                        100

      Top 5                    7500                      800                        940                        680

      Toutou                    500                       100                        80                           60

      …                           …                        …                          …                           …                      …

       

      Do you know how can I have this result ?

       

      Thank you

      Regards

      Bérengère