|
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. |
