Hi.
I'm trying to make an income statement report. For this, I'm making a pivot table with sales data, costs data and utility data. When I load the script, the table looks like this:
Month Sales Costs Utility
1 10 5 5
2 13 7 6
3 15 8 7
But I need that the table looks like this:
Month 1 2 3
Sales 10 13 15
Costs 5 7 8
Utility 5 6 7
How can I get that? Somebody suggests me use the function Crosstable, but I could not add it in my script. The code tha I'm using is this:
D_LIBROMAYOR:
CrossTable ([Nombre Cuenta Reporting],[Mvto Mes])
load * from
(qvd);
D_LIBROMAYOR_2:
LOAD
*, [Nombre Cuenta Reporting],
[Mvto Mes],
Mes
Resident D_LIBROMAYOR;
Anybody has any suggestion? Thank you for the collaboration.
Jairo Medina
.png "Luminary Alumni"){kind=icon}