Question: how do i do this: Copy the pivot Grand Total amount to a cell (or reference it with GETPIVOTDATA). Suppose Grand Total is in cell

how do i do this: Copy the pivot Grand Total amount to a cell (or reference it with GETPIVOTDATA). Suppose Grand Total is in cell B15 (check your pivot). Create: Top10_Total = SUM of the 10 visible Total Sales cells (e.g., =SUM(B5:B14)) All_Others = Grand_Total - Top10_Total AllOthers% = All_Others / Grand_Total

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

1. Formulas (Show each formula in the blue shaded area next to the data in your Excel file) - 1 point - Calculate new data using the VLOOKUP function. In cell L4, enter a formula to match Customers...

Steps to Step 1 2 5 6 7 8 9 m: Instructions Start Excel. Open exploring ecap_grader_c2_Transactions.xlsx and save the workbook as exploring_ecap_grader_c2_Transactions_LastFirst. On the June Totals...

HI Invoicelu" Contract" InvoiceD Invoiceitem Invoiced: InvoiceF 1011 8111 2/2712021 Indoor alarm system 500.00 TRUE 1012 9111 5/10/2021 Indoor alarm system $ 1,500.00 TRUE 1021 9112 2/25/2021 Front...

Data link: https://drive.google.com/drive/folders/1txHtl8_W2u1rUnGwdgDONyfg22KVKWUP?usp=sharing CAS 171 - Final Project: Computer Warehouse Data Files: ComputerWarehouse.accdb,...

In this project, you will analyze sales data using consolidation, subtotals, outlines, conditional formatting, advanced filters, PivotTables, and PivotCharts. Skills needed to complete this project:...

can someone help me with this please let me know if you need more info Required information [The following information applies to the questions displayed below.) This Applying Excel worksheet...

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

Please explain each step. Possible 9 4 The Summary sheet is designed to display two key averages from the PivotTable on the Summary sheet. Project Description: You are an analyst for a fine art...

Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows: Direct material: 4...

Bird D. Consider yet again the birds suffering from mites and lice. For each bird, find Var(P) directly from the probability distribution of P = L + M. Show how you could have found the variance with...

When would using the FFO invertery costing method produce higher inversory accourt balances than the uro method would? Inflatonary times deflationarytimes slways never

The new trade theory states that: A). The locus of global production initially switches from the United States to other advanced nations. B). World trade in certain products may be dominated by...