Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Pivot Table - Add Pick % Totals

Copper Contributor

Hi All,


Is there a way to add what is displayed in column W (Daily Total) into the pivot table itself?


I would like for it all to be connected instead of having that separate column with the math and formulas to get the desired information. 


Thank you

2 Replies


You could at least simplify your formula and do without the auxiliary columns.



Thats really helpful. I figured there was an easy way to not utilize those extra columns. I inherited these sheets and have been trying to learn excel since.

I'll see if there is a way to incorporate that formula into the pivot table itself.

Thanks again