Use the Index Summary Calculation in a PivotTable

Want to know how the Dow Jones Index or S&P 500 Index works? You came to the right video! Okay I won't really show you how to do the calculations, but I'll show you how to do an index summary calculation in a Pivot Table that takes on the similar concepts. It uses an aggregated weighted average to reveal the impact of one number within the context of a data set. To really understand this, check out the video.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@excelisfun]

Thanks for the Relative Impact!

[@DougHExcel]

Thanks Mike!

[@orangefly3263]

Much interesting . I like your video. Thanks

[@DougHExcel]

You're Welcome! Glad you liked!

[@stevesullivan457]

Nice job Doug

[@DougHExcel]

Thanks Steve!

[@pipo441]

Thanks. Great tutorial.

[@DougHExcel]

You're welcome!

[@williamarthur4801]

Still not sure what it's supposed to do ( sorry) made a two column table; items, unit,
pivot table sum units count items, set both to index everything = 1 ?

[@pipo441]

Learned something new today. Never too late. Thanks. However I have a PIVOT table where grand row total did not appear. So I added a calculated field for Row total. However the INDEX function does not make the calculation. It shows one while when I make copy paste and do the INDEX calculation by means of the formula it shows the Index result. Any thoughts on this?

[@DougHExcel]

Pivot table should have the option to put the grand total under tab Desgin>Layout.

[@pipo441]

@@DougHExcel I am mixing up things, my apologies. So I added a calculated field with totals in a right column.... Do you have a tutorial video with a more basic example? I don't get it why it doesn't work...

[@DougHExcel]

maybe this one ua-cam.com/video/-sirg1EcMwQ/v-deo.html

[@user-qo4gn5iz3j]

thank you very much but want to know the code to make statement to customer in all movement looping code.please

[@DougHExcel]

I don't know VBA well, but you can try to pose your question to the mrexcel.com forum.

[@user-qo4gn5iz3j]

thank you very much about your answer this appear you are respectable man thank you another time

[@munawararbab8073]

I understand, Sir What is benefits mean where we use INDEX?

[@williamarthur4801]

I still don't know what it's supposed to do, I tried a few things and they all cam back as 1?