Question: I Need to get the calculation that is in a Data sheet column to work in the Pivot Table - I've tried several different ways

I Need to get the calculation that is in a Data sheet column to work in the Pivot Table - I've tried several different ways and it only sums it doesn't perform the SUMPRODUCT like it does in the other table. =SUMPRODUCT(G6:G7,F6:F7)/SUM(F6:F7) is the calculation used in the spreadsheet but when I try running it in a calculated field within the Pivot table it doesn't work. Here is what I have in the Pivot table but it just sums and doesn't do the SumProduct =SUMPRODUCT(CapRate,MemberMonths)/SUM(MemberMonths)

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!

Use cost structure concepts (ie fixed costs, variable costs, semi variable costs mixed costs, and step costs step fixed costs) to answer the following questions Suppose the community college wants to...

COSC1702AB21SS-Project5 Ques 1.Problem: You are employed in the personnel office of a major corporation. You asked each of your three branch offices to send you an updated list of their employees...

Rev.Confirming Pages C H A P T E R 7 Planning, Composing, and Revising Chapter Outline The Ways Good Writers Write Activities in the Composing Process Using Your Time Effectively Brainstorming,...

elaborate a one to two (1-2) paragraph max analysis from your work up to this point. Your report should consider: What business recommendations will you give Label XYZ in regards to the...

please answer all questions with the given excel sheet and show work please Arial 10 ' ' = = Date ID Paste Conditional Form 9. Format us Table Cell Styles LU BI INI $ % ) a89 H2 Xfx 4/1/2021 A B D E...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

For some background. My goal is to be able to view quartile calculations of a row a data (multiple columns) in a pivot table. I want to be able to adjust the quartile calculations by toggling on and...

(1) Income Statement Referencing this week?s readings and lecture, address the following: ? What are the two causes of an increasing or decreasing sales number? ? Discuss all the reasons that might...

You recently joined Grand and Toy as an accounting intern. The accounting manager, Sophie Lamda, met with you and handed over your first assignment. Sophie: Good morning intern, welcome to Grand and...

This chapter presents students and early career executives with a sound understanding of theory. Theory is explored in terms of both anatomy (parts of the whole) and physiology (relationships with...

Please answer with the vlookup formula needed for the "Customer Status" in Part 3 and formulas needed for Parts 4-6 (ignore parts 1-2). Part 1: ETL with the OrderId field Let's decide that the rule...

We will fire the carts again (leaving each mass at 1 kg), but this time we will give them an initial velocity before the explosion. Do this by setting the initial velocity to +2 m/s for either cart,...

In 2019. Marigold sold 3000 units at $500 each. Variable expenses were $250 per unit, and fixed expenses were $360000. The same selling price is expected for 2020. Marigold is tentatively planning to...

5 Write the answers to these calculations in index form. a 103102 b 20520 c 153153 d 55 53

In 2022, Draper Company discovered errors made in 2019-2021, its first three years of operation. 2021 2020 2019 Items not recognized: Prepaid expenses $1,300 $900 $550 Accrued expenses 950 700 800...