Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cross Tab
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cross Tab
Miscellaneous
Thread ID:
00270932
Message ID:
00270932
Views:
55
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
Shahid
Next
Reply
Map
View

Click here to load this message in the networking platform