Forum Discussion

Bahama85's avatar
Bahama85
Copper Contributor
Nov 24, 2022

Pivot Table - Add Pick % Totals

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

    • Bahama85's avatar
      Bahama85
      Copper Contributor
      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

Resources