pivot tables

Question

pivot tables

lavanya.pothu

SSC Enthusiast

Points: 101
More actions
September 17, 2009 at 1:13 am

#99872

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Dugi SSCoach Points: 17998 More actions · Answer 1

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:

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

LutzM SSC Guru Points: 107049 More actions · Answer 2

Please read and follow the link in my signature on how to post sample data.

You could also check one of Jeff's articles regarding Cross Tabs[/url].

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Dugi SSCoach Points: 17998 More actions · Answer 3

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).

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]