Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a pie chart in Tableau that shows the percentage of the company's total costs that are product costs and the percentage that are period

image text in transcribed

Create a pie chart in Tableau that shows the percentage of the company's total costs that are product costs and the percentage that are period costs: Double click on "Sheet 1" at the bottom of your workbook and rename it "Product vs. Period Costs" . On the lefthand side under "Dimensions" (sometimes labeled as Tables), click on "Product / Period" and drag it to the "Columns" area above the blank sheet. On the lefthand side under "Measures", click on "Amount" and drag it to the "Rows" area. The calculation will default to Sum; however, we want to modify this to show the percentage breakdown. To do this, click on the dropdown inside the green pill that currently says SUM(Amount) and select "Quick Table Calculation" then choose "Percent of Total" This will create a vertical bar chart that we will change to a pie chart in the next step. In the upper righthand corner of the screen, click on "Show Me," then select the "Pie Chart" option in the 2nd rows down in the far-right column To improve viewing, locate the "Standard" dropdown option in the menu bar at the top of the screen. Click on that dropdown and choose "Entire View." To insert numerical values in your pie chart, click the Text button() in the menu bar at the top of the screen. Notice that the color legend in the upper righthand corner of the screen defines the blue portion of the pie as period costs and the orange portion of the pie as product costs. Your visualization should appear as follows: Pages Columns Rows Filters Product vs. Period Costs Product / Period Period Product Marks % of Total SUM(Amount) 100.004 Pe Color Size 25.1196 OD Det. To An Produ SU SU. 74.899 Required: 1a. What percentage of the company's total costs are product costs? 1b. What percentage of the company's total costs are period costs? (For all requirements, round your answers to 2 decimal places.) 1-a. % Percentage of product costs Percentage of period costs 1-b. %

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost management a strategic approach

Authors: Edward J. Blocher, David E. Stout, Gary Cokins

5th edition

73526940, 978-0073526942

More Books

Students also viewed these Accounting questions

Question

Address an envelope properly.

Answered: 1 week ago

Question

Discuss guidelines for ethical business communication.

Answered: 1 week ago