Question 14 - Salesforce Analytics-Con-301 Real Exam Questions [Feb 2026 Update]

Q: 14

SIMULATION Use the following login credentials to sign in to the virtual machine: Username: Admin Password: The following information is for technical support purposes only: Lab Instance: 40201223 To access Tableau Help, you can open the Help.pdf file on the desktop. From the desktop, open the CC workbook. Open the Categorical Sales worksheet. You need to use table calculations to compute the following: . For each category and year, calculate the average sales by segment. . Create another calculation to compute the year-over-year percentage change of the average sales by category calculation. Replace the original measure with the year- over-year percentage change in the crosstab. From the File menu in Tableau Desktop, click Save.

Your Answer

Correct Answer:

ON THE CATEGORICAL SALES WORKSHEET, LOCATE THE AVG(SALES) MEASURE PILL (IF IT IS SUM(SALES), RIGHT-CLICK IT AND CHANGE THE AGGREGATION TO MEASURE (AVERAGE)).
RIGHT-CLICK THE AVG(SALES) PILL AND SELECT EDIT TABLE CALCULATION....
PRIMARY CALCULATION:

SET CALCULATION TYPE TO AVERAGE.
SET COMPUTE USING TO SPECIFIC DIMENSIONS.
CHECK ONLY SEGMENT.

CLICK ADD SECONDARY CALCULATION.
SECONDARY CALCULATION:

SET SECONDARY CALCULATION TYPE TO PERCENT DIFFERENCE FROM.
SET COMPUTE USING TO SPECIFIC DIMENSIONS.
CHECK ONLY YEAR(ORDER DATE).

CLOSE THE TABLE CALCULATION DIALOG BOX.
FROM THE FILE MENU, CLICK SAVE.

Explanation

This task requires a nested table calculation (also known as a secondary table calculation) to satisfy both requirements.

The primary calculation addresses the first bullet: "calculate the average sales by segment." By setting the Calculation Type to Average and computing using Segment, Tableau first averages the sales figures for the Consumer, Corporate, and Home Office segments for each Category/Year intersection.
The secondary calculation addresses the second bullet: "compute the year-over-year percentage change." By adding a secondary calculation of Percent Difference From and computing using YEAR(Order Date), Tableau takes the result of the first calculation (the average) and computes its percentage change from the previous year.

References

Tableau (Salesforce) Official Documentation. Tableau Desktop and Web Authoring Help. "Add a secondary table calculation".

Reference: This document explicitly details the procedure for applying a secondary calculation to a measure that already has a primary table calculation. It states, "You can add a secondary table calculation to a measure that already has a table calculation applied to it... For example, you can apply a primary table calculation to calculate the yearly running total of sales, and then apply a secondary table calculation to calculate the year-over-year percent difference."

Tableau (Salesforce) Official Documentation. Tableau Desktop and Web Authoring Help. "Table Calculation Types".

Reference: Section: Percent Difference From. This reference confirms that Percent Difference From is the correct calculation type for this scenario, as it "computes the percent difference from the previous value in the partition."

Tableau (Salesforce) Official Documentation. Tableau Desktop and Web Authoring Help. "Transform Values with Table Calculations".

Reference: Section: Compute Using. This guide explains the necessity of using Specific Dimensions to control the scope and direction of the calculation. For the primary calculation, the scope is Segment; for the secondary, the scope is YEAR(Order Date).

MIT Libraries. Data Management and Visualization Guide. "Tableau: Table Calculations".

Reference: This university courseware guide confirms the nature of table calculations, stating they "are computed based on what is currently in the visualization" and can be used for "percent of total... [and] percent difference". It reinforces the use of these functions on the data present in the crosstab.

Premium Access Includes

FLASH OFFER

avail 10% DISCOUNT on YOUR PURCHASE