I am trying to run a pivot table and get the total number of cartons by SKU and all I can get is the total number of carton ID's which equals overall quantity. I have attached the spreadsheet. Hopefully someone can help or message me and assist further.
Project Packing List(23).xls
Thanks
Cameron
I tried to use the file you attached, but was unable to create a PT from your data, so i created a new file, copy/pasted your data and created a basic PT for you, usint SKU's as the reference. hope this helps
Please
[1] Use code tags. Place "[ code ]" before the first line of code and "[/code]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
[3] Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post
Hi ttcam and welcome to the forum.
See if the attached isn't what you want.
One test is worth a thousand opinions.
Click the * below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks