Afternoon,
I tried unsuccessfully to add a calculated field in attached work book - see "Daily_Pivot" tab, Add % Total m3 column for each product item.
Second, I tried without success to Group & Collapse Daily Package count columns and only show the Total = I could only Group and Collapse both daily m3 and packet counts
My source data is from tabular worksheet called 'S.Mill_Data'
Any assistance is greatly appreciated.
Regards,
Garth Buck
Hi Garth,
Welcome to our forum! Please try uploading your file again. You need to click the 'Start Upload' button after selecting your file, then wait for the grey check mark beside the file size before clicking Submit Reply.
Mynda
Hi Mynda,
Hopefully, my upload file now works.
Happy New Year 2022
Garth
Hi Garth,
HNY to you too!
The file hasn't uploaded. Maybe it's too big for the forum limit? When it uploads correctly you will see it attached in your post. If it's too big, you can create a smaller mock-up of your file.
Mynda
Lol. I sliced and diced the file. It worked now 🙂
I see a grey tick mark
Thx, Garth
Glad you got the PivotTable doing what you want....and managed to share the file 🙂
Hi Mynda,
I tried unsuccessfully to add a calculated field in attached work book above - see "S.M._Pivot _Sept'21" tab.
I am unable to add " % Total m3" column for each product item. RE: I need to be able to see % of each product for Total column
Any help is appreciated.
Hi Garth,
Please try uploading the file again. Be sure to click the Start Upload button after selecting your file and then wait for the grey check mark beside the file size before clicking Submit Reply.
Mynda
