Question: Appendix B This case has you do a deeper analysis of the valuation and allocation assertion for Inventory. Open the Tableau packaged workbook called Inventory
Appendix B This case has you do a deeper analysis of the valuation and allocation assertion for Inventory. Open the Tableau packaged workbook called "Inventory Case" Click on Sheet 1 and call it Visualization 1. Calculate a new variable called Margin o Right click underneath the measures (the green variables in the Tables pane) and select Create Calculated Field o Name the field 'Margin' o The equation should be ([Sales Price1 from the Shipping section minus Unit Cost from the Inventory section])*Ship Quantity from the Shipping section. Press OK. Hint: make sure you include the parentheses around the price minus cost expression, otherwise your margin will be incorrectly calculated and incorrectly summed later on! Drag "Product Number1" from the Shipping portion into the Columns field. Drag "Ship Quantity" from the Shipping portion into the Rows field. Click on Show Me and change the view to Packed Bubbles. Drag and drop "Margin" onto the "Color" section of the "Marks" tab
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
