Matching
Match each of the following Show Value as Options to its best description:
Premises:
No Calculation
% of Grand Total
% of Column Total
% of Row Total
% of Parent Row Total
Responses:
Default value shows the raw summary of the value.
Each value displays as a percentage of the whole and adds up to 100%.
Each value displays as a percentage of the column.
Each value displays as a percentage of the hierarchical level above it.
Each value shows as a percentage of the row.
Correct Answer:
Premises:
Responses:
No Calculation
% of Grand Total
% of Column Total
% of Row Total
% of Parent Row Total
Premises:
No Calculation
% of Grand Total
% of Column Total
% of Row Total
% of Parent Row Total
Responses:
Related Questions
Q7: What would you do to format all
Q8: The _ function is the default summary
Q9: If you would like to show a
Q10: If you have related data stored in
Q11: Using the % of Grand Total Calculation
Q13: You are analyzing sales data and eating
Q14: You can clear all fields from a
Q15: How would you add a date filter
Q16: Build a PivotChart in the PivotChart wizard
Q17: What dictates the order of hierarchy of