I have order numbers in one column, items in another and amount in another.
The sheet is prepared according to the item. But, I would like to calculate
what is the amount for each order.
I could do it with the help of Pivot, but i hav some more fields required
like this and i am unable to do that through pivot. Is there any way I can
use?