Salesforce Analytics-Con-301 Salesforce Certified Tableau Consultant Exam Practice Test

Given the need for up-to-date data on a daily basis and weekly revisions, the best approach is to use an incremental extract refresh daily to update the data source with new transactions. On Saturdays, when incorrect transactions are revised, a full extract refresh should be performed to incorporate all revisions and ensure the data’s accuracy. This strategy allows end users to have access to the most current data throughout the week while also accounting for any necessary corrections12.

To minimize the impact on users when reverting to a previous version of a published data source in Tableau Server, the consultant should use the built-in revision history feature. By selecting a previous version from the revision history and clicking ‘Restore’, the data source will revert to that version without the need for a full server backup restoration or manual recreation of the data source. This process is quick and has the least amount of disruption to users.

For optimal performance, it is recommended to limit the data to what is necessary for analysis, which in this case would be the current and previous years. Moving the calculation of averages to the data layer and aggregating the dates to a monthly level will reduce the granularity of the data, thereby improving the performance of the dashboard. This approach aligns with best practices for optimizing workbook performance in Tableau, which suggest simplifying the data model and reducing the number of records processed12.

To improve performance by moving calculations to the data layer and materializing them in the extract, the consultant should choose calculations that benefit from pre-computation and significantly reduce the load during query time:

Aggregation-Level Calculation: The formula SUM([Profit])/SUM([Sales]) calculates a ratio at an aggregate level, which is ideal for pre-computation. Materializing this calculation in the extract means that the complex division operation is done once and stored, rather than being recalculated every time the report is accessed.

Performance Improvement: By pre-computing this aggregate ratio, Tableau can utilize the pre-calculated fields directly in visualizations, which speeds up report loading and interaction times as the heavy lifting of data processing is done during the data preparation stage.

To improve the performance of a Tableau workbook, it is best practice to streamline the data being used. This can be achieved by using filters to limit the data to only what is necessary for analysis, hiding fields that are not being used to reduce the complexity of the data model, and aggregating values to simplify the data and reduce the number of rows that need to be processed. These steps can help reduce the load on the server and improve the speed of the workbook.

In Tableau, the performance of calculated fields can vary based on the data type used. Calculations involving integers and Booleans are generally faster than those involving strings. This is because numerical operations are typically more efficient for a computer to process than string operations, which can be more complex and time-consuming. Therefore, when performance is a consideration, it is advisable to use integers or Booleans over strings whenever possible.

The most efficient way to limit report visibility to specific user groups on Tableau Server is to manage permissions directly on the server. By granting access to the report only to the sales and marketing user groups, the client ensures that only members of these groups can view the report. This method is straightforward and does not require the additional steps involved in setting up row-level security or user filters.

To improve the performance of a Tableau dashboard while maintaining accurate counts, particularly when dealing with unknown or NULL BrowserIDs in the data tables, the following steps are recommended:

Modify the Browser Table: Add a new row to the Browser Table labeled "Unknown," assigning it a unique BrowserID, e.g., 0 or 4.

Update the Site Visitor Table: Replace all NULL BrowserID entries with the BrowserID assigned to the "Unknown" entry. This ensures every record in the Site Visitor Table has a valid BrowserID that corresponds to an entry in the Browser Table.

Change Referential Integrity Setting: Change the Referential Integrity setting from "Some Records Match" to "All Records Match." This change assumes all records in the primary table have corresponding records in the secondary table, which improves query performance by allowing Tableau to make optimizations based on this assumption.

The calculation {FIXED [Customer ID], [Region]: COUNTD([Order ID])} is the correct one to use for this scenario. This Level of Detail (LOD) expression will calculate the distinct count of orders for each customer within each region, which is then averaged per month. This approach ensures that the average number of orders per customer is accurately calculated for each region and then broken down by month, aligning with the client’s expectations.

When “Apply to Nested Projects” is checked in Tableau Server, the permission rules set at the top-level project are enforced for all assets in the project and all nested projects. This means that any custom access previously granted to nested projects will be overridden, and the permissions will revert to those defined at the top-level project. This action ensures consistent application of the data governance strategy across all divisions.

Comprehensive and Detailed Explanation From Exact Extract:

The requirement is to compare each quarter’s profit to the median profit over a rolling window of the last four quarters, including the current one. This is a classic use case for WINDOW_ table calculations in Tableau.

Tableau documentation explains:

WINDOW_MEDIAN( expression, start, end ) computes the median of the expression over a window of rows defined by start and end, which are offsets relative to the current row.

To create a rolling calculation that includes the current row and the three preceding rows, the window frame must span four rows ending at the current row.

Conceptually, the correct pattern is:

Current quarter’s profit: SUM([Profit])

Rolling four-quarter median: WINDOW_MEDIAN(SUM([Profit]), previous_3, current)

In actual Tableau syntax, that pattern is written with a frame that begins three rows before the current row and ends at the current row.

Among the options provided:

Options A and B use INDEX() or FIRST() as the start of the window, which creates frames anchored to either the first row or varying positions in the partition, not a consistent four-quarter trailing window.

Option D anchors the frame relative to LAST(), which makes the window depend on the final row in the partition, not a trailing four-quarter window for each bar.

Option C uses a fixed frame of four rows expressed as (3, 0) in the argument list. While, in exact Tableau syntax, a trailing 4-row frame is typically written with a negative start offset and zero as the end offset, this option is clearly intended to represent the frame “three rows back through the current row” and is therefore the only answer that matches the required rolling four-quarter window conceptually.

So, using a WINDOW_MEDIAN over a four-row frame ending at the current row, as shown in option C, is the intended solution for coloring each bar based on whether:

SUM([Profit]) > rolling_median_over_last_4_quarters

Tableau table calculation reference describing WINDOW_ functions and their start/end frame parameters.

Examples in Tableau help that use WINDOW_SUM or WINDOW_AVG with a frame spanning a fixed number of previous rows to compute rolling-window metrics.

Best practices for using WINDOW_MEDIAN to compute rolling medians over sliding time windows.

The most user-friendly solution is to use Dynamic Zone Visibility in combination with a Show/Hide Button. This approach allows the dashboard to dynamically display only the relevant quick filters based on the viewer’s selection of shops or warehouses, thus reducing clutter and focusing the user’s attention on applicable filters. The Show/Hide Button further enhances the user experience by allowing viewers to toggle the visibility of the filter container, providing a clean and organized dashboard interface1.

For a client who needs a daily visualization of widget inventory but cannot modify the data warehouse structure, the best approach is to use Tableau Prep to add new rows. Tableau Prep can be used to manipulate the existing dataset by adding missing date entries and appropriately adjusting inventory counts based on available data. This allows the creation of a complete daily snapshot for visualization without needing changes to the underlying database structure.

Comprehensive and Detailed Explanation From Exact Extract:

The requirement is:

Compute total sales per customer, not per transaction.

Then compute the average of those customer totals, grouped by region.

Tableau documentation states that FIXED LOD expressions are used to calculate values at a specific level of granularity regardless of the view.

To solve the business need:

Step 1:

Calculate total customer sales for each Customer ID within each Region:

{ FIXED [Customer ID], [Region] : SUM([Sales Amount]) }

This produces one number per customer per region.

Step 2:

Compute the average of those totals:

AVG( { FIXED [Customer ID], [Region] : SUM([Sales Amount]) } )

This yields:

Average total customer sales by region

This is exactly option C.

Why the other options are incorrect:

A. EXCLUDE Region: Would combine regions and incorrectly calculate overall totals.

B. FIXED Region: AVG(Sales Amount): Computes average of line-level sales, not customer totals.

D. FIXED Customer ID + Region: AVG(Sales Amount): Averages individual transactions, not customer totals.

Only option C matches the required two-step logic.

LOD Expressions: FIXED for computing customer-level aggregates.

Nested LOD usage for first calculating customer totals, then averaging them at a higher level.

Tableau guidance: SUM inside FIXED for per-customer totals, AVG outside for averaging customers.

Comprehensive and Detailed Explanation From Exact Extract:

In Tableau Performance Recording, “Executing Query” refers to the amount of time Tableau spends executing the SQL or hyper query generated by the workbook. When an extract is used, the query is executed against the .hyper extract, not the original database.

Tableau documentation identifies several causes of slow query execution within extracts, including:

Nested row-level calculations

Complex logic in calculated fields

Multiple Levels of Detail (LOD) expressions

Non-optimized expressions that force Tableau to compute additional temporary tables

These directly increase query complexity and cause longer “Executing Query” durations.

Therefore, optimizing the query requires simplifying or replacing:

Nested calculations

Unnecessary LOD expressions

Complex expressions that increase the workload on the extract engine

Option A is incorrect because the number of VizQL processes affects concurrency, not query execution time.

Option B is partially relevant, but dashboard filters affect the overall workload, not the specific query complexity. If the performance recording shows “Executing Query” as the slow section, the query itself (not the filter UI layer) is the problem.

Option D does not apply because extracts use the hyper engine, not the underlying database. Optimizing the original database structure does not change the extract query execution time.

Thus, the consultant should focus on simplifying nested calculations and LODs to reduce extract query complexity.

Tableau Performance Recording guide describing “Executing Query” as dependent on calculation complexity.

Tableau extract engine documentation explaining that nested logic, multiple LODs, and granular calculations generate slower extract queries.

Best practices recommending simplification of calculated fields to improve extract query performance.

Comprehensive and Detailed Explanation From Exact Extract:

The dataset contains timestamps for each individual user interaction. Growth in user adoption over 6 months means the number of rows has expanded significantly. Tableau’s performance documentation states that large row-level datasets can cause performance degradation even when using extracts, especially when:

The visualization is aggregated to a higher level (such as daily), and

The underlying extract still contains much more granular data than needed.

Tableau recommends pre-aggregating data before it reaches Tableau Desktop, which reduces extract size, memory use, and query time. This improves performance without changing what the visualization displays.

Option D uses Tableau Prep, which is included with Tableau Creator licensing and therefore incurs no additional cost. Tableau Prep can aggregate raw timestamp data into daily totals per product feature, which matches the visualization’s actual granularity. This results in:

A dramatically smaller extract

Faster queries

No change to how the dashboard looks or functions

Option A would remove product features from the visualization, altering the dashboard content and reducing insight, which does not meet the requirement of minimal impact.

Option B requires purchasing an external ETL tool, which violates the requirement of no additional cost.

Option C reduces the number of extract refreshes but does not improve dashboard performance; the data would remain equally granular and equally slow.

Therefore, Tableau Prep aggregation is the correct solution that improves performance while maintaining the same visualization and incurring no additional cost.

Tableau performance guidelines recommending pre-aggregation of highly granular datasets.

Tableau Prep documentation stating it can be used to aggregate data before creation of extracts.

Tableau’s extract optimization guidance describing how reducing row counts improves query and visualization performance.

The correct calculation to count all distinct orders placed in 2010 involves placing the conditional inside the aggregation function, not the other way around. Here's how to correct the client's calculation:

Original Calculation Issue: The client’s original calculation attempts to apply the COUNTD function within an IF statement, which does not work as expected because the COUNTD function cannot conditionally count within the scope of the IF statement.

Correct Calculation: COUNTD(IF YEAR([Date]) = 2010 THEN [OrderID] END). This calculation checks each order date; if the year is 2010, it returns the OrderID. The COUNTD function then counts all unique OrderIDs that meet this condition.

Why It Works: This method ensures that each order is first checked for the year condition before being counted, effectively filtering and counting in one step. It efficiently processes the data by focusing the distinct count operation only on relevant records.

References

This approach is consistent with Tableau's guidance on using conditional logic inside aggregation functions for accurate and efficient data calculations, as detailed in the Tableau User Guide under "Aggregations and Calculations".

Tableau’s built-in geocoding supports only the following geographic roles:

Country

State / Province

County

City

Postal Code

Airport

Area codes

Congressional districts, etc.

Tableau does NOT natively geocode street-level addresses.

When a dataset contains street address fields, Tableau will not recognize them as geographic fields because:

Street Address 1 and Street Address 2 are not valid Tableau geographic roles.

Tableau cannot automatically translate street text (like “101 Random Place Rd”) into latitude/longitude.

Therefore, to plot street-level points on a map, Tableau requires:

Custom geocoding OR latitude/longitude fields.

Tableau documents that for exact address locations:

You must either supply latitude and longitude for each address, or

Use custom geocoding, where the user uploads a .csv with addresses matched to coordinates.

Why the other answer choices are incorrect:

B. Change the data type to Geographic role

Street address fields cannot be assigned a geographic role. Tableau will reject them or not map them.

C. Establish a hierarchy

Hierarchies help with drilldown but do not generate geographic coordinates for street addresses.

D. Add a map layer

Map layers allow visual overlays but cannot generate geocoding for address fields.

The only correct way to map street addresses is to custom geocode (or supply lat/long), which matches option A.

Tableau Geocoding documentation stating street-level addresses are not natively supported.

Custom Geocoding instructions for mapping exact address points.

Mapping best practices stating that lat/long or custom geocode files are required for street accuracy.

Comprehensive and Detailed Explanation From Exact Extract:

The key detail of the question:

“filter out particular categories, but wants the percent of total calculation to remain steady even as they filter items in or out.”

This means the percent of total must ignore filters.

Table calculations always operate after filters, except table calc filters like "Filter on Table Calculation," and after dimension filters, so filtering categories directly will change the denominator.

Tableau’s documented solution for “percent of total that does not change with filtering” is:

✔ Use a FIXED LOD to define the stable denominator

A FIXED LOD expression “freezes” the aggregation level and is unaffected by dimension filters unless explicitly added to context.

This allows the consultant to compute:

{ FIXED : SUM([Sales]) }

or

{ FIXED [Category] : SUM([Sales]) }

Then percent of total becomes:

SUM([Sales]) / { FIXED : SUM([Sales]) }

The FIXED LOD stores the total before filters are applied, ensuring the percent remains steady.

This is exactly what Tableau documentation explains under:

Level of Detail Expressions

LODs and Order of Operations

Using LODs to create filter-independent calculations

Thus, D is correct.

Why the other answers are wrong:

✘ A. Context Filter

Context filters run before FIXED LODs but after raw data.

If Category is put into context, LOD totals would be reduced.

Table calculation totals still change because table calcs run near the bottom of the pipeline.

✘ B. Data Source Filter

Data source filters remove rows before all table calculations and LODs.

This would make the percent of total incorrect, because filtered-out categories would physically be gone.

✘ C. Aggregate Expression

An aggregate field alone does not solve the issue because it still respects dimension filters.

The problem:

The client wants:

Percent of total sales for each region compared to ALL regions,

even when Region is filtered.

However, the calculation currently behaves like a table calculation:

SUM([Sales]) / TOTAL(SUM([Sales]))

This recalculates the total after Region filters are applied, so removing a region changes the denominator.

Tableau Documentation — How to prevent recalculation:

To keep percent-of-total unchanged when filtering, Tableau’s recommended method is to use FIXED LOD expressions to lock the granularity.

Two values must be fixed:

Numerator: Sales for that specific region{ FIXED [Region] : SUM([Sales]) }

Denominator: Total sales across all regions, independent of filters{ FIXED : SUM([Sales]) }(FIXED with no dimension = entire data set)

Then compute the percentage:

{ FIXED [Region] : SUM([Sales]) } / { FIXED : SUM([Sales]) }

This ensures:

The region sales remain accurate.

The overall total remains constant, even if filters remove regions.

Region filtering no longer recalculates percent-of-total.

Why the other options are incorrect:

A. {FIXED [Region]: SUM([Sales])} / SUM([Sales])

The denominator is still affected by filters → recalculates % of total.

B. {FIXED [Region]: SUM([Sales])} / { [Sales] }

{[Sales]} is not valid syntax and does not fix granularity.

D. {FIXED [Region]: SUM([Sales])}

This gives only the numerator — no percent-of-total calculation.

The only correct LOD solution is option C.

Tableau LOD Expression Guide: FIXED for filter-independent calculations.

Tableau Percent-of-Total Best Practices: use FIXED LOD to avoid recalculation when filters change.

Order of Operations: FIXED LODs occur before dimension filters, keeping totals stable.

To complete the Pareto chart in the "City Pareto" worksheet of your Tableau Desktop and add reference lines to illustrate how the data compares to the Pareto principle, follow these steps:

Open the CC Workbook and Access the Worksheet:

From the desktop, double-click on the CC workbook to open it in Tableau Desktop.

Navigate to the City Pareto worksheet by selecting its tab at the bottom of the window.

Construct the Pareto Chart:

Ensure that sales data is aggregated by city. If not, drag the 'City' dimension to the Columns shelf and the 'Sales' measure to the Rows shelf.

Sort the sales data in descending order to properly align the cities according to their sales contribution.

To create a running total of sales, right-click on the 'Sales' measure on the Rows shelf, select 'Quick Table Calculation', and choose 'Running Total'.

Drag the 'Number of Records' field to the Rows shelf next to the Sales running total. Right-click on it, select 'Quick Table Calculation', and choose 'Running Total'. Set its calculation to 'Percent of Total' from the 'Edit Table Calculation' option to represent the percentage of cities.

Add Reference Lines for the Pareto Principle:

Click on the Analytics tab in the sidebar.

Drag a 'Reference Line' element and drop it onto the chart area.

Set the Reference Line for the Sales axis at 80% to represent the typical Pareto cutoff where 80% of effects come from 20% of causes.

Add another Reference Line on the axis representing the percentage of cities, set at 20%, to visually assess the Pareto principle.

Adjust the Appearance of the Chart:

Format the reference lines by right-clicking on them, selecting 'Edit', and choosing a distinct style or color to make them stand out.

Ensure the chart is clear and labels are appropriately adjusted for easy understanding of the data visualization.

Save Your Changes:

From the File menu, click 'Save' to ensure all your changes are stored.

To modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression and accurately calculate the percentage contribution of each manufacturer to the total quantity, follow these steps:

Open the CC Workbook and Access the Worksheet:

Double-click on the CC workbook from the desktop to open it in Tableau Desktop.

Navigate to the Manufacturers worksheet by selecting its tab at the bottom of the window.

Modify the Percent Contribution Calculated Field:

Navigate to the Data pane and find the "Percent Contribution" calculated field.

Right-click on the "Percent Contribution" field and select 'Edit'.

Modify the formula to incorporate an LOD expression that calculates the total quantity across all manufacturers and the specific quantity per manufacturer:

{FIXED [Manufacturer]: SUM([Quantity])} / {SUM([Quantity])}Quantity])}

This formula uses {FIXED [Manufacturer]: SUM([Quantity])} to compute the total quantity contributed by each manufacturer, regardless of other dimensions in the view. The total quantity {SUM([Quantity])} calculates the grand total across all manufacturers. The division calculates the percentage contribution.

Click 'OK' to save the updated calculated field.

Enter Percentage for Newell:

With the updated "Percent Contribution" field, drag it onto the view to update the chart or table.

Identify the value corresponding to 'Newell' in the updated visualization.

Round this value to the nearest hundredth of a percent as required.

Enter this value into the "Newell % Contribution" parameter. To do this, locate the parameter in the Data pane or on the dashboard, right-click it, and choose 'Edit'. Enter the calculated percentage for Newell.

Save Your Changes:

From the File menu, click 'Save' to store all the modifications you have made to the workbook.

To add a line showing the cumulative percentage of sales contributed by each product to the incremental sales in the Incremental worksheet of your Tableau Desktop, follow these detailed steps:

Open the CC Workbook and Access the Worksheet:

From the desktop, double-click on the CC workbook to open it in Tableau Desktop.

Navigate to the Incremental worksheet by clicking on its tab at the bottom of the window.

Calculate Cumulative Sales Percentage:

Create a new calculated field to compute the cumulative percentage of sales. Right-click in the Data pane and select 'Create Calculated Field'.

Name this field "Cumulative Sales Percentage".

Enter the following formula to calculate the running sum of sales as a percentage of the total sales:

(RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) [Sales]))

Click 'OK' to save the calculated field.

Add the Cumulative Sales Percentage Line to the Chart:

Drag the "Cumulative Sales Percentage" field to the Rows shelf, placing it next to the existing Sales measure.

Ensure that the cumulative line appears as a continuous line. Right-click on the "Cumulative Sales Percentage" field on the Rows shelf, select 'Change Chart Type', and choose 'Line'.

Adjust the axis to synchronize or dual-axis if necessary. Right-click on the axis of the "Cumulative Sales Percentage" and select 'Synchronize Axis' if it's on a dual-axis setup.

Format the Cumulative Sales Percentage Line:

Click on the "Cumulative Sales Percentage" line in the visualization.

Navigate to the 'Format' pane to adjust the line style, thickness, and color to make it distinct from other data in the chart.

Save Your Changes:

From the File menu, click 'Save' to ensure all your changes are stored.

To shape the data in the "US Population Estimates" data source and enter the total number of records into the "Total Records" parameter in Tableau Desktop, follow these steps:

Open the CC Workbook and Access the Worksheet:

From the desktop, double-click on the CC workbook to open it in Tableau Desktop.

Navigate to the Population worksheet by selecting its tab at the bottom of the window.

Format and Shape the Data:

Ensure the data types match those specified in the requirements: Sex, Origin, Race as strings; Year, Age, Population as whole numbers.

To verify or change the data type, click on the dropdown arrow next to each field name in the Data pane and select "Change Data Type" if necessary.

Calculate Total Number of Records:

Create a new calculated field named "Total Records". To do this, right-click in the Data pane and select "Create Calculated Field".

Enter the formula COUNT([Record ID]) or SUM([Number of Records]) depending on how the data source identifies each row uniquely.

Drag this new calculated field onto the worksheet to display the total number of records.

Enter the Value into the Total Records Parameter:

Locate the "Total Records" parameter in the Data pane. Right-click on the parameter and select "Edit".

Manually enter the number displayed from the calculated field into the parameter, ensuring accuracy to meet the data shaping requirement.

Save Your Changes:

From the File menu, click 'Save' to ensure all your changes are stored.

To record the performance of the Property Transactions dashboard in the NYC Property Transactions.twbx workbook and analyze it using a bar chart, follow these detailed steps:

Open the NYC Property Transactions Workbook:

From the desktop, double-click the NYC Property Transactions.twbx workbook to open it in Tableau Desktop.

Start Performance Recording:

Before doing anything else, navigate to the 'Help' menu in Tableau Desktop.

Select 'Settings and Performance', then choose 'Start Performance Recording'.

Open the Property Transactions Dashboard and Reset Filters:

Navigate to the Property Transactions dashboard within the workbook.

Reset all filters to show all values. This usually involves selecting the dropdown on each filter and choosing 'All' or using a 'Reset' button if available.

Stop the Performance Recording:

Go back to the 'Help' menu.

Choose 'Settings and Performance', then select 'Stop Performance Recording'.

Tableau will automatically open a new tab displaying the performance recording results.

Save the Performance Recording:

In the performance recording results tab, go to the 'File' menu.

Click 'Save As' and navigate to the C:\CC\Data\ directory.

Save the file, ensuring it is stored in the desired location.

Create a New Worksheet for Performance Analysis:

Return to the NYC Property Transactions workbook and create a new worksheet by clicking on the 'New Worksheet' icon.

Drag the 'Command Name' field to the Columns shelf.

Drag the 'Elapsed Time' field to the Rows shelf.

Ensure that the 'Worksheet' field is also included in the analysis to break down the time by individual sheets within the dashboard.

Choose 'Bar Chart' from the 'Show Me' options to display the data as a bar chart.

Customize and Finalize the Bar Chart:

Adjust the axes and labels to clearly display the information.

Format the chart to enhance readability, applying color coding or sorting as needed to emphasize sheets with longer load times.

Save Your Work:

Once the new worksheet and the performance recording are complete, ensure all work is saved.

Navigate to the 'File' menu and click 'Save', confirming that changes are stored in the workbook.

To compute the required calculations and update the worksheet in Tableau Desktop, follow these steps:

Compute Average Sales by Segment for Each Category and Year:

Open the CC workbook and navigate to the Categorical Sales worksheet.

Drag the 'Sales' field to the Rows shelf if it's not already there.

Drag the 'Segment' field to the Rows shelf as well, placing it next to 'Category' and 'Year'.

Right-click on the 'Sales' field in the Rows shelf and select 'Quick Table Calculation' > 'Average'. This will compute the average sales for each segment within each category and year.

Create a Calculation for Year-over-Year Percentage Change:

Right-click in the data pane and select 'Create Calculated Field'.

Name the calculated field something descriptive, e.g., "YoY Sales Change".

Enter the formula to calculate the year-over-year percentage change:

(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))

Click 'OK' to save the calculated field.

Replace the Original Measure with the Year-over-Year Percentage Change in the Crosstab:

Remove the original 'Sales' measure from the view by dragging it off the Rows shelf.

Drag the newly created "YoY Sales Change" calculated field to the Rows shelf where the 'Sales' field was originally.

Format the "YoY Sales Change" field to display as a percentage. Right-click on the field in the Rows shelf, select 'Format', and adjust the number format to percentage.

Save Your Changes:

From the File menu, click 'Save' to ensure all your changes are stored.