September 17, 2009 at 1:13 am
i want pivot tables for the following data
West Mumbai Arrow Women Lacie Maroon 34B
West Mumbai Arrow Women Lacie Maroon 36B
West Mumbai Arrow Women Lacie Maroon 38D
West Mumbai Arrow Women Lacie Maroon 40B
West Mumbai Arrow Women Lacie Maroon 40C
West Mumbai Arrow Women Lacie Maroon 40D
West Mumbai Arrow Women Lacie Gray 34B
West Mumbai Arrow Women Lacie Gray 36B
West Mumbai Arrow Women Lacie Gray 38D
West Mumbai Arrow Women Lacie Gray 40B
West Mumbai Arrow Women Lacie Gray 40C
West Mumbai Arrow Women Lacie Gray 40D
West Mumbai Arrow Women Trim Fit Red 32A
West Mumbai Arrow Women Trim Fit Red 32B
West Mumbai Arrow Women Trim Fit Red 32C
West Mumbai Arrow Women Trim Fit Red 34A
West Mumbai Arrow Women Trim Fit Red 34B
West Mumbai Arrow Women Trim Fit Blue 32A
West Mumbai Arrow Women Trim Fit Blue 32B
West Mumbai Arrow Women Trim Fit Blue 32C
West Mumbai Arrow Women Trim Fit green 32A
West Mumbai Arrow Women Trim Fit green 32B
West Mumbai Arrow Women Trim Fit green 32C
West Mumbai Arrow Women Trim Fit green 34A
West Mumbai Arrow Women Trim Fit green 34B
West Mumbai Arrow Women Trim Fit green 34C
West Mumbai Arrow Women Trim Fit green 34D
West Mumbai Arrow Women Trim Fit green 36A
West Mumbai Arrow Women style1 Yellow S
West Mumbai Arrow Women style1 Yellow M
West Mumbai Arrow Women style1 Yellow L
West Mumbai Arrow Women style2 Blue S
West Mumbai Arrow Women style2 Blue M
West Mumbai Arrow Women style2 Blue L
West Mumbai Arrow Women style2 black S
West Mumbai Arrow Women style2 black M
West Mumbai Arrow Women style2 black L
West Mumbai Arrow Women style1 black S
West Mumbai Arrow Women style1 black M
West Mumbai Arrow Women style1 black L
West Mumbai Arrow Women style1 white S
West Mumbai Arrow Women style1 white M
West Mumbai Arrow Women style1 white L
South Hyderabad Louis Phillippe Trim Fit Red 32A
South Hyderabad Louis Phillippe Trim Fit Red 32B
South Hyderabad Louis Phillippe Trim Fit Red 32C
South Hyderabad Louis Phillippe Trim Fit Red 34A
South Hyderabad Louis Phillippe Trim Fit Red 34B
South Hyderabad Louis Phillippe Trim Fit Red 34C
South Hyderabad Louis Phillippe Trim Fit Blue 32A
South Hyderabad Louis Phillippe Trim Fit Blue 32B
South Hyderabad Louis Phillippe Trim Fit Blue 32C
South Hyderabad Louis Phillippe Trim Fit Blue 34A
South Hyderabad Louis Phillippe Trim Fit Blue 34B
South Hyderabad Louis Phillippe style2 Blue S
South Hyderabad Louis Phillippe style2 Blue M
South Hyderabad Louis Phillippe style2 Blue L
East Guwahati Levis Trim Fit Red 32A
East Guwahati Levis Trim Fit Red 32B
East Guwahati Levis Trim Fit Red 32C
East Guwahati Levis Trim Fit Red 34A
East Guwahati Levis Trim Fit Red 34B
East Guwahati Levis Trim Fit Red 34C
East Guwahati Levis Trim Fit Red 34D
East Guwahati Levis Trim Fit Red 36A
East Guwahati Levis style2 black S
East Guwahati Levis style2 black M
East Guwahati Levis style2 black L
East Guwahati Levis style2 Blue S
East Guwahati Levis style2 Blue M
East Guwahati Levis style2 Blue L
East Guwahati Levis Trim Fit Red 32A
East Guwahati Levis Trim Fit Red 32B
East Guwahati Levis Trim Fit Red 32C
East Guwahati Levis Trim Fit Red 34A
East Guwahati Levis Trim Fit Red 34B
East Guwahati Levis Trim Fit Red 34C
East Guwahati Levis Trim Fit Red 34D
East Guwahati Levis Trim Fit Red 36A
September 17, 2009 at 3:32 am
So the data will look like...!? Seems that you should post the example how to look your data, anyway no correct solution for your problem!
:hehe:
September 17, 2009 at 3:46 am
Yes, Lutz's proposal is good point to start with Pivota querying, anyway as you can see in Lutz's signature and also my signature you have the link where you can find the information for the best way and practice to post the question and sure that you will have the best way solution with many alternatives(if it possible).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply