An analyst has a bar chart showing total sales for each month of the year. They want to modify the chart to show the cumulative sales as the year progresses. Which quick table calculation would achieve this result?
Running Total
Percent of Total
Moving Average
Difference
The correct answer is 'Running Total'. This quick table calculation computes a cumulative total of a measure across a defined partition. In this scenario, it would sum the sales of each month with the sales of the preceding months, showing the cumulative total. 'Percent of Total' would show each month's sales as a percentage of the annual total. 'Moving Average' is used to smooth out data fluctuations to identify trends. 'Difference' would calculate the month-over-month change in sales.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
All IT & Cybersecurity Package plans include the following perks and exams .
Our pricing is simple. Full access to all certifications and exams in each package, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
Access to our AI assistant, Bash, trained to help you pass your exam.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even bigger discounts than before.
Unlimited access to all performance questions and be prepared for the real thing.
All IT & Cybersecurity Package plans include unlimited access to the following study materials.
Create an account or sign in to access our study materials.