Question: In cell K 1 0 , enter a formula that uses the GETPIVOTDATA function. b . Using Payment as the data field, extract data from
In cell K enter a formula that uses the GETPIVOTDATA function. bUsing "Payment" as the data field, extract data from the Pivot Table starting in cell A on the Monthly Payments worksheet. Use an absolute reference to the cell.CSelect the grand total quantity amount for Auto policies by using "Policy Type" as the fieldi argument and the name of the policy type cell J of the Clients worksheet as the item argument.dFill the range K:K with the formula in cell K filling the range without forma
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
