Forum Discussion

Bahama85's avatar
Bahama85
Tin 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 ...
excel
Formulas and Functions
office 365
dscheikey's avatar
dscheikey
Bronze Contributor
Nov 24, 2022

Bahama85 

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

=SUMPRODUCT(INDEX(C8:V8,SEQUENCE(5,1,2,4)),INDEX(C8:V8,SEQUENCE(5,1,4,4)))/SUM(D8,H8,L8,P8,T8)

 

  • Bahama85's avatar
    Bahama85
    Tin Contributor
    Nov 24, 2022
    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