Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The best way to show counts of the receivables in column C in the pivots is to: Add another instance of Amount to the
The best way to show counts of the receivables in column C in the pivots is to: Add another instance of Amount to the pivot tables with the appropriate field value settings and formatting Determine the counts with the count() function in the receivables sheet and reference them in the pivots sheet Counts cannot be added reliably because they would change with different data for Customer, CreditDate, and Amount Counts would be undesirable because they would replace values showing as Sum of Amount in the pivot tables
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started