How to add a column in a cross table - R/R

building reports desktopintelligence
1

Hy,

After our request, we have a table with :

  • Month 200601 200501
  • Nb_fly 88 44
  • Nb_Pax 1500 700

We want to add a column which done :
R/R=(Nb_fly(200601) - Nb_fly(200501)) / Nb_fly(200601)
R/R=(Nb_Pax(200601) - Nb_pax(200501)) / Nb_pax(200601)

The result we want is :

  • Month 200601 200501 R/R
  • Nb_fly 88 44 0.50
  • Nb_Pax 1500 700 0.53

Can somebody help us please?

boudaudr :fr: (BOB member since 2005-02-01)

2

By selecting two columns and applying variance you can add a column. After adding the column, you need to edit the formula.

peacock (BOB member since 2002-11-07)

3

Hi,
If you want to add the column in the table before the cross tab
(i mean before cross tab’s objects) then you can just add to the column section of the cross tab
else if you want to add after the cross tab objects then please click on teh cross tab objets then click on Sum and you will get the sum for each row.

So edit this row to get the new variable.

After such rows are added then you can just add a new row if you want to add and new column after this one.

Omkar Paranjpe :us: (BOB member since 2006-02-13)

4

Hi,

Thanks for your help.
My point is not how to add a row, but how to define the formula of this row which does R/R=(Nb_fly(200601) - Nb_fly(200501)) / Nb_fly(200601)…

boudaudr :fr: (BOB member since 2005-02-01)

5

Hi,
is the option “Show Footer” is enabled in the Format Table side?

then highlighting that row, you can insert any number of rows below or above this footer

Omkar Paranjpe :us: (BOB member since 2006-02-13)

6

Hi,

Thanks for your help but it is really not my problem.

My point is I want define a formula which do

=(Nb_fly(column1) - Nb_fly(column2)) / Nb_fly(column1)…
And I do not know how to do that.

boudaudr :fr: (BOB member since 2005-02-01)