Nov 24 2022 07:57 AM
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
Nov 24 2022 08:54 AM
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)
Nov 24 2022 09:29 AM