Forum

Notifications
Clear all

Calculated Field and Group Data

8 Posts
2 Users
0 Reactions
163 Views
(@garthbuck)
Posts: 4
Active Member
Topic starter
 

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

 
Posted : 31/12/2021 12:57 am
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 31/12/2021 1:58 am
(@garthbuck)
Posts: 4
Active Member
Topic starter
 

Hi Mynda,

Hopefully, my upload file now works.

Happy New Year 2022

Garth

 
Posted : 01/01/2022 6:13 pm
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 01/01/2022 8:23 pm
(@garthbuck)
Posts: 4
Active Member
Topic starter
 

Lol.  I sliced and diced the file.  It worked now 🙂

I see a grey tick mark

 

Thx, Garth

 
Posted : 01/01/2022 9:20 pm
(@mynda)
Posts: 4761
Member Admin
 

Glad you got the PivotTable doing what you want....and managed to share the file 🙂

 
Posted : 02/01/2022 9:25 pm
(@garthbuck)
Posts: 4
Active Member
Topic starter
 

 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.

 
Posted : 01/02/2022 3:56 am
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 01/02/2022 5:38 am
Share: