groupwise top 3 items [message #7937] |
Thu, 17 July 2003 06:55 |
ARANGASWAMY.V.
Messages: 29 Registered: April 2002
|
Junior Member |
|
|
companies are paying different rates of taxes for each items manufactured by them.
I wanted to take the sum of the taxes (paid by the companies)company-wise item-wise only top 3 items (for each company).
ex:
company tax item
opel-astra $20 car
opel-astra $222 car
opel-astra $12 van
opel-astra $35 van
opel-astra $21 bus
Honda $11 two wheeler
Honda $65 two wheeler
Honda $47 two wheeler
Honda $31 four wheeler
Honda $91 sports car
Honda $23 sports car
|
|
|