You have the following worksheet.

You want to create a table calculation that shows sales growth over each year.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

Correct Answer:

Explanation:
There are different ways to create a table calculation that shows sales growth over each year, but one possible answer is:
* SUM([Sales])
* LOOKUP(SUM([Sales]), -1)
* PREVIOUS_VALUE(0)
To calculate the sales growth over each year, you need to compare the current year's sales with the previous year's sales and divide the difference by the previous year's sales. You can use the SUM, LOOKUP, and PREVIOUS_VALUE functions to achieve this. The SUM function returns the total sales for each year. The LOOKUP function returns the value of an expression in a target row, specified as a relative offset from the current row. The PREVIOUS_VALUE function returns the value of the expression in the previous row, or a specified value if there is no previous row. The formula for the table calculation is:
(SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / PREVIOUS_VALUE(0)
This formula subtracts the sales of the previous year (LOOKUP(SUM([Sales]), -1)) from the sales of the current year (SUM([Sales])) and divides the result by the sales of the previous year. If there is no previous year, the formula uses 0 as the denominator (PREVIOUS_VALUE(0)) to avoid division by zero errors.
References:
Tableau Certified Data Analyst Exam Prep Guide, page 11, section "Creating Calculated Fields" Tableau Help: SUM Function Tableau Help: LOOKUP Function Tableau Help: PREVIOUS_VALUE Function

Comment: *

Name: *

Email: *

Verification: *

You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis.
You need to configure be shapes to be much larger than the line.
What should you do?

• A.Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently
• B.Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository
• C.For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset
• D.Change Population to a discrete dimension

Comment: *

Name: *

Email: *

Verification: *