Forum Discussion
Excel pivot table index option
Good evening, I have a question: Pivot tables have an option called "Show values as" and in turn have several categories. One of these categories is "Index". On the microsoft page they specify the ...
Thanks Sergei, what I need to know about the Index formula of the pivot table is to show that it is valid mathematically. Is there a theorem or mathematical law that supports this formula?
If about math perhaps these links will be useful
1.3 Paasche's Price Index - YouTube
1.4 Laspeyre's Price Index - YouTube
Pivot Table Index Function | MrExcel Message Board