| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting pivot to show finctions data calcs across columns, not down rows
Hi, I have some data like (# rows obviously paired down for size):
this thing1 50 this thing1 70 this thing1 12 this thing2 75 this thing2 20 this thing2 100 this thing2 90 that thing1 200 that thing1 150 that thing1 122 that thing3 40 that thing3 42 that thing3 38 other thing1 20 other thing1 22 other thing1 50 other thing3 32 other thing3 38 other thing3 20 The calc functions I need to do are Counts, Min, Max, Avg. This is what I can get.... but below this is what I need. Item1 Item2 Data Total other thing1 Count 3 Min 20 Max 50 Average 30.7 thing3 Count 3 Min 20 Max 38 Average 30.0 that thing1 Count 3 Min 122 Max 200 Average 157.3 thing3 Count 3 Min 38 Max 42 Average 40.0 this thing1 Count 3 Min 12 Max 70 Average 44.0 thing2 Count 4 Min 20 Max 100 Average 71.3 What I need is something like this: Is this doable via pivot? If yes, how? Item1 Item2 Count Min Max Average other thing1 3 20 50 30.7 thing3 3 20 38 30 that thing1 3 122 200 157.3 thing3 3 38 42 40 this thing1 3 12 70 44 thing2 4 20 100 71.3 Pete Derkowski |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
getting pivot to show finctions data calcs across columns, not down rows
Sorry, the cut/pastes didn't come out very good....
Here is the data: this thing1 50 this thing1 70 this thing1 12 this thing2 75 this thing2 20 this thing2 100 this thing2 90 that thing1 200 that thing1 150 that thing1 122 that thing3 40 that thing3 42 that thing3 38 other thing1 20 other thing1 22 other thing1 50 other thing3 32 other thing3 38 other thing3 20 What I get is like: : Item1 Item2 Data other thing1 Count 3 Min 20 Max 50 Average 30.7 thing3 Count 3 Min 20 Max 38 Average 30.0 that thing1 Count 3 Min 122 Max 200 Average 157.3 thing3 Count 3 Min 38 Max 42 Average 40.0 this thing1 Count 3 Min 12 Max 70 Average 44.0 thing2 Count 4 Min 20 Max 100 Average 71.3 What I need is something like: Item1 Item2 Count Min Max Average other thing1 3 20 50 30.7 thing3 3 20 38 30 that thing1 3 122 200 157.3 thing3 3 38 42 40 this thing1 3 12 70 44 thing2 4 20 100 71.3 Hope this formates rights when I save it.. Pete Derkowski "Pete Derkowski" wrote in message ... Hi, I have some data like (# rows obviously paired down for size): this thing1 50 this thing1 70 this thing1 12 this thing2 75 this thing2 20 this thing2 100 this thing2 90 that thing1 200 that thing1 150 that thing1 122 that thing3 40 that thing3 42 that thing3 38 other thing1 20 other thing1 22 other thing1 50 other thing3 32 other thing3 38 other thing3 20 The calc functions I need to do are Counts, Min, Max, Avg. This is what I can get.... but below this is what I need. What I need is something like this: Is this doable via pivot? If yes, how? Item1 Item2 Count Min Max Average other thing1 3 20 50 30.7 thing3 3 20 38 30 that thing1 3 122 200 157.3 thing3 3 38 42 40 this thing1 3 12 70 44 thing2 4 20 100 71.3 Pete Derkowski |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
getting pivot to show finctions data calcs across columns, not downrows
Take a look at Debra Dalgleish's video and you'll be slapping your forehead in
moments: http://contextures.com/xlVideo001.html Pete Derkowski wrote: Sorry, the cut/pastes didn't come out very good.... Here is the data: this thing1 50 this thing1 70 this thing1 12 this thing2 75 this thing2 20 this thing2 100 this thing2 90 that thing1 200 that thing1 150 that thing1 122 that thing3 40 that thing3 42 that thing3 38 other thing1 20 other thing1 22 other thing1 50 other thing3 32 other thing3 38 other thing3 20 What I get is like: : Item1 Item2 Data other thing1 Count 3 Min 20 Max 50 Average 30.7 thing3 Count 3 Min 20 Max 38 Average 30.0 that thing1 Count 3 Min 122 Max 200 Average 157.3 thing3 Count 3 Min 38 Max 42 Average 40.0 this thing1 Count 3 Min 12 Max 70 Average 44.0 thing2 Count 4 Min 20 Max 100 Average 71.3 What I need is something like: Item1 Item2 Count Min Max Average other thing1 3 20 50 30.7 thing3 3 20 38 30 that thing1 3 122 200 157.3 thing3 3 38 42 40 this thing1 3 12 70 44 thing2 4 20 100 71.3 Hope this formates rights when I save it.. Pete Derkowski "Pete Derkowski" wrote in message ... Hi, I have some data like (# rows obviously paired down for size): this thing1 50 this thing1 70 this thing1 12 this thing2 75 this thing2 20 this thing2 100 this thing2 90 that thing1 200 that thing1 150 that thing1 122 that thing3 40 that thing3 42 that thing3 38 other thing1 20 other thing1 22 other thing1 50 other thing3 32 other thing3 38 other thing3 20 The calc functions I need to do are Counts, Min, Max, Avg. This is what I can get.... but below this is what I need. What I need is something like this: Is this doable via pivot? If yes, how? Item1 Item2 Count Min Max Average other thing1 3 20 50 30.7 thing3 3 20 38 30 that thing1 3 122 200 157.3 thing3 3 38 42 40 this thing1 3 12 70 44 thing2 4 20 100 71.3 Pete Derkowski -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
getting pivot to show finctions data calcs across columns, not down rows
Holy Crapola!! And to think of all the time I spent the other nite trying to figure out what menu selection and what options to change to do this... I was finally dragging and dropping things left and right in layout... I just didn't do the right drag and drop. Thanks a Million! Pete "Dave Peterson" wrote in message ... Take a look at Debra Dalgleish's video and you'll be slapping your forehead in moments: http://contextures.com/xlVideo001.html Pete Derkowski wrote: Sorry, the cut/pastes didn't come out very good.... Here is the data: this thing1 50 this thing1 70 this thing1 12 this thing2 75 this thing2 20 this thing2 100 this thing2 90 that thing1 200 that thing1 150 that thing1 122 that thing3 40 that thing3 42 that thing3 38 other thing1 20 other thing1 22 other thing1 50 other thing3 32 other thing3 38 other thing3 20 What I get is like: : Item1 Item2 Data other thing1 Count 3 Min 20 Max 50 Average 30.7 thing3 Count 3 Min 20 Max 38 Average 30.0 that thing1 Count 3 Min 122 Max 200 Average 157.3 thing3 Count 3 Min 38 Max 42 Average 40.0 this thing1 Count 3 Min 12 Max 70 Average 44.0 thing2 Count 4 Min 20 Max 100 Average 71.3 What I need is something like: Item1 Item2 Count Min Max Average other thing1 3 20 50 30.7 thing3 3 20 38 30 that thing1 3 122 200 157.3 thing3 3 38 42 40 this thing1 3 12 70 44 thing2 4 20 100 71.3 Hope this formates rights when I save it.. Pete Derkowski "Pete Derkowski" wrote in message ... Hi, I have some data like (# rows obviously paired down for size): this thing1 50 this thing1 70 this thing1 12 this thing2 75 this thing2 20 this thing2 100 this thing2 90 that thing1 200 that thing1 150 that thing1 122 that thing3 40 that thing3 42 that thing3 38 other thing1 20 other thing1 22 other thing1 50 other thing3 32 other thing3 38 other thing3 20 The calc functions I need to do are Counts, Min, Max, Avg. This is what I can get.... but below this is what I need. What I need is something like this: Is this doable via pivot? If yes, how? Item1 Item2 Count Min Max Average other thing1 3 20 50 30.7 thing3 3 20 38 30 that thing1 3 122 200 157.3 thing3 3 38 42 40 this thing1 3 12 70 44 thing2 4 20 100 71.3 Pete Derkowski -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to pivot my data from columns to rows | Excel Discussion (Misc queries) | |||
| show sereral columns of data field in pivot table | New Users to Excel | |||
| pivot tables-drop data in, how to make it show as columns instead | Excel Discussion (Misc queries) | |||
| Putting data into pivot tables in columns not rows. | Excel Discussion (Misc queries) | |||
| How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
Linear Mode
