I have a list of values on Shippers and because there are more than one line with the same item and same shipment value it is combining/grouping the two lines as one. I need to find a way to display these lines separately without altering the source data by adding a line item.
shipper part qty total
570894 7005397-002 CSP/BGA OVERMOLDED 202 1017
7005397-002 CSP/BGA OVERMOLDED 303 1017
7005397-002 CSP/BGA OVERMOLDED 310 1017
There are two lines with a qty of 202 and excels pivot only includes the line once but without the total line there would be no way to know info might be missing. It should display 202, 202, 303, 310. How can I achieve this?
Bookmarks