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

Q: 13

SIMULATION From the desktop, open the CC workbook. Open the Manufacturers worksheet. The Manufacturers worksheet is used to analyze the quantity of items contributed by each manufacturer. You need to modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression that calculates the percentage contribution of each manufacturer to the total quantity. Enter the percentage for Newell to the nearest hundredth of a percent into the Newell % Contribution parameter. From the File menu in Tableau Desktop, click Save.

Your Answer

Correct Answer:

THIS IS A SIMULATION TASK. THE FINAL NUMERICAL VALUE FOR "NEWELL" CANNOT BE DETERMINED WITHOUT ACCESS TO THE "CC WORKBOOK" DATA FILE.

THE CORRECT LEVEL OF DETAIL (LOD) EXPRESSION TO MODIFY THE PERCENT CONTRIBUTION CALCULATED FIELD IS: SUM([QUANTITY]) / SUM({FIXED : SUM([QUANTITY])})

Explanation

The goal is to calculate each manufacturer's contribution to the total quantity.

SUM([Quantity]): This aggregation calculates the quantity for the level of detail in the view (i.e., for each manufacturer).
{FIXED : SUM([Quantity])}: This FIXED LOD expression calculates the grand total quantity across the entire dataset, independent of the dimensions or filters* in the view.
Dividing the manufacturer's sum by this fixed grand total provides the correct percentage contribution.

After applying this formula, you would identify the value for "Newell" and enter it into the specified parameter.

(*Note: FIXED LOD expressions are computed before dimension filters. If filters are present and should apply to this calculation, they must be added to context.)

References

Tableau (Official Vendor Documentation). (2024). Create Level of Detail Expressions in Tableau. Tableau Help.

Section: "FIXED"

Relevance: This document explains that FIXED level of detail expressions "compute values using the specified dimensions, without reference to the dimensions in the view." Using {FIXED : SUM([Quantity])} without any specified dimensions computes the total sum for the entire context, which is required for the denominator.

Tableau (Official Vendor Documentation). (2024). Overview: Level of Detail Expressions. Tableau Help.

Section: "Aggregation and Level of Detail Expressions"

Relevance: This document clarifies how Tableau aggregates the results of an LOD expression. In the formula SUM([Quantity]) / SUM({FIXED : SUM([Quantity])}), the denominator is aggregated as SUM() because the LOD expression itself returns a single, non-aggregated value (the grand total) that is duplicated for every row.

Tableau (Official Vendor Documentation). (2024). Top 15 LOD Expressions (Whitepaper).

Section: Example 2, "Percent of Total"

Relevance: This official whitepaper provides a canonical example of using an LOD expression for a "Percent of Total" calculation, often using the formula {FIXED [Dimension] : SUM([Sales])} / {FIXED : SUM([Sales])}. The formula provided in the answer, SUM([Quantity]) / SUM({FIXED : SUM([Quantity])}), is an equivalent and efficient way to achieve this when [Manufacturer] is already in the view.

Premium Access Includes

FLASH OFFER

avail 10% DISCOUNT on YOUR PURCHASE