I would like to know how to divive cross tab columns.

 

I created cross tab like Country as rows and region,city, employ code is columns with hierarcal way and country sales as summarid values.

 

i get  data like below format

 

                    Newyork      delhi               australia Regoin

                     city             Newdelhi          Sydney

                      24               20                     25

Australia       1000           5000               2000

 

India              300             600                 900

 

Usa               500              2000                700

 

I would like to display the values of 'INDIA' instead of 300, 600,900, I need to display the values as USA value/Australia value

 

Thanks in Advance.

Thanks for your reply. I found the answer.

 

we select that numeration group and right click then we select first process that field and goto th denominator field and apply the quotient operation. then it will display the division values of two fields.

 

We right click the Quotien field and selct 'edit row header' and give the name as India. we the india group in select expert.

 

Regards,

Naga.