Skip to Content
0
Former Member
Oct 22, 2013 at 05:32 PM

How to add a calculed line in a crosstab

19 Views

Hi Experts

I have a crosstab like this


01/02/2012 02/03/2012 01/04/2012 01/05/2012 31/05/2012 chantier 1 904 1 868 1 721 1 543 1 927 HS 12 16 10 10 10 Immo 2 118 2 114 2 105 2 138 2 143 Loc 178 175 324 520 141 REP 24 30 50 65 65

I want to add a line under this crosstab with a formula like this


01/02/2012 02/03/2012 01/04/2012 01/05/2012 31/05/2012 chantier 1 904 1 868 1 721 1 543 1 927 HS 12 16 10 10 10 Immo 2 118 2 114 2 105 2 138 2 143 Loc 178 175 324 520 141 REP 24 30 50 65 65

Ratio 90 15 30 40 60

And Ratio is a formula like this Chantier/(Immo-HS)*100

Have you an idea to make this

Thank's