Thus, you can calculate the index number for any value by using the formula below: STEP 7: Divide them and you will get the Index! STEP 6: Multiply the Grand Row Total of Bottles and the Grand Column Total of Americas. STEP 5: Select the Sales for Bottles-Americas then multiply it by the Grand Total. Let us target the Bottles Sales for the Americas Region. Now let’s have a quick calculation to show how Index is calculated. STEP 4: Now we have our Index values! The higher value means that it is the most important value for that column, for example, Bottles have the greatest impact on the Americas Region in terms of sales. STEP 3: Select Show values as > Index. Click OK STEP 2: Go to the second Pivot Table, and click on the arrow of Sum of SALES and select Value Field Settings
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |