ultratch47
Board Regular
- Joined
- Aug 6, 2002
- Messages
- 126
i have been tring to do this for a LONGG time... i give up and beg for assistance!!
when i make the pivot table the 2nd column has 3 rows for one slection on the first column...
what i want is for it to list these three seperate rows all on the same row, so it take sup less space, and so i can sort the data by a column.
it looks like this (off topic "?", how do i show an excel doc on this forumn)
i have about 6000 rows of data, this data has 5 columns i want to view
if the item appears more than once, it is listed on more than one row, so first thing, i want to see how many of each item on the report (count of item)
now i just want to list the price and the description to the right of this on the same row...
any suggestions?
i currently put:
item on data ( to get the count
item on row (to get the item #)
price on data ( to list the max price)
description on data ( to list the desc of item)
but this gives me 3 rows for each item (count of item, desc, and price)
thank you VERRRY much in advance... if i can tackle a pivot table after this, my life is a lot less stressful..
ps. yes i have tried reading help and what not, but too no avail
when i make the pivot table the 2nd column has 3 rows for one slection on the first column...
what i want is for it to list these three seperate rows all on the same row, so it take sup less space, and so i can sort the data by a column.
it looks like this (off topic "?", how do i show an excel doc on this forumn)
i have about 6000 rows of data, this data has 5 columns i want to view
if the item appears more than once, it is listed on more than one row, so first thing, i want to see how many of each item on the report (count of item)
now i just want to list the price and the description to the right of this on the same row...
any suggestions?
i currently put:
item on data ( to get the count
item on row (to get the item #)
price on data ( to list the max price)
description on data ( to list the desc of item)
but this gives me 3 rows for each item (count of item, desc, and price)
thank you VERRRY much in advance... if i can tackle a pivot table after this, my life is a lot less stressful..
ps. yes i have tried reading help and what not, but too no avail