Pivot Table - Add Pick % Totals

Question

Hi All,&nbsp;Is there a way to add what is displayed in column W (Daily Total) into the pivot table itself?&nbsp;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.&nbsp;&nbsp;Thank you

dscheikey · Answer

Bahama85&nbsp;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)&nbsp;

bahama85 · Answer

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

Forum Discussion

Pivot Table - Add Pick % Totals

Share

Resources