I'm looking for a way to generate cross tab with 3 columns for every store 
where 
number of stores in not hard coded.
Every store info should contain 3 columns:

turnover
budget
budget percent (=turnover/budget*100)

Result should look like:

Acc   st1turnover   st1budget st1percent  ...   stNturnover  st1budget 
stNpercent
311   100           200        50                 200  ...        300       67
312   400           500        80                 600  ...        700       86  
          
...

I tried crosstab from tablefunc but it allows only single value in every 
crosstabled column. 

How to show 3 values in every column: sales, budget and percent in this order?

Tables are:

create table sales (
  account char(10), 
  store char(10),
  sales  numeric(12,2) );
 
insert into sales values 
('311','ST1',100)... ('311','STN',200)
('312','ST1',400)... ('312','STN',600);

create table budget (
  account char(10), 
  store char(10),
  budget numeric(12,2) );
 
insert into budger values 
('311','ST1',200)... ('311','STN',300)
('312','ST1',500)... ('312','STN',700);
 

Some account and store values may be missing from tables.

Andrus.

Reply via email to