Hi I have a report showing:
Item # Description Price Qty
1xyz xyz 15.00 1-12
the qty has 3 different values for each item ex. 1-12 13-24 25 or more.
When I sort by Qty then item# I get all the 1-12 then all the 13-24 and so on, what I want is to keep all the different qty for each item together under each other like this
1xyz xyz 15.00 1-12
1xyz xyz 12.00 13-24
1xyz xyz 10.00 25 or more
How can I get it to do this??
Thanks
Item # Description Price Qty
1xyz xyz 15.00 1-12
the qty has 3 different values for each item ex. 1-12 13-24 25 or more.
When I sort by Qty then item# I get all the 1-12 then all the 13-24 and so on, what I want is to keep all the different qty for each item together under each other like this
1xyz xyz 15.00 1-12
1xyz xyz 12.00 13-24
1xyz xyz 10.00 25 or more
How can I get it to do this??
Thanks