Dear all,
I'm coping a big problem, for me of course, but I'm not able to go on
I have the following tables:
Details
Year Month Area GLaccount Value
2012 01 xy 1 150000
2012 01 xy 2 50000
2012 02 xy 3 150000
2012 02 aa 1 50000
2012 02 aa 2 40000
...
Purchase
Year Month Area Total Purchase
2012 01 xy 250000
2012 02 xy 100000
2012 02 aa 100000
I need to produce the following pivot for 2012
GlAccount Value
AREA TOTALpurchase 1 % 2 % 3 %
xy 350000 150000 42,85 50000 14,30 150000 42,85
aa 90000 50000 55,55 40000 44,45
The percentage values, are calculated as GLaccount_Value_for area/Total purchase for area
I don't know how to solve it.
Help please
Thanks in advance