>>>Dear All
>>>
>>>I want to cross tab more that one field (transform),Can i do this in vfp 5 if so how Can i do this...?
>>>e.g
>>>Table struture
>>>
>>>area_id, product_id, sale, target
>>>---------------------------------
>>>1 A 1200 1400
>>>2 B 1000 1200
>>>3 C 5600 4000
>>>4 D 2000 1000
>>>
>>>I want to convert the product_id to columns and the data against this, if have to use it again and again, can anybody help me in this regard.
>>>
>>>Thanks
>>>
>>>Shahid Saleem
>>
>>
Check vfpxtab.prg. Also you can design a query and set the destination to cross tab then view SQL to see what VFP calls for Cross Tabbing.
>>Cetin
>
>Dear Cetin
>
>Thanks for guidance, I have read that file named vfpxtab.prg that file take Row field , and a column field and a data field as input, but in my requirment in want to pass 2 or more than two columns as data field, can u help me in this regard,,
>
>Shahid Saleem
If you need more than one data field you could design your own. Or using provided prg :
-You could do seperate crostabs for each data field.
Alternatively you could use Excel pivot tables that let you do it with multipl pages, rows, columns and data fields.
Cetin