atoolz

  Please download the dataset   Click for dataset You have sales data for office products. To compare 2018 and 2019 sales for product category and sub-category, build a bar-in-bar chart that shows 2018 sales as a small bar on top of 2019 sales as a larger bar. Good luck! Build a side-by-side view with 2018 Sales and 2019 Sales by Category and Sub-Category . From the Data pane: Drag 2018 Sales to Columns . Drag Category to Rows . Drag Sub-Category to Rows , and place it to the right of Category . From the Data pane, drag 2019 Sales to the 2018 Sales axis (the horizontal axis), dropping it when two green bars appear. NOTE: Step 2 places Measure Values on Columns, and Measure Names on Rows and the Filters card. Stack the bars by adding Measure Names to Color and to Size . From Rows , drag Measure Names to Color on the Marks card. This stacks the marks. On the Marks card, press and hold the Ctrl key while dragging Measure Names to Size . This adds a copy of ...

  Please download the dataset   Click for dataset You’re looking at your organization’s sales data, and you want to see the relative contribution of each product category and region to your total sales. To determine this, you’ll build a tree map. Good luck! Build a tree map showing Sales of each Category in each Region . From the Data pane: Drag Sales to Size on the Marks card. Drag Region to Color on the Marks card.  Drag Category to Detail on the Marks card.  If a tree map is not displayed, change the mark type to Automatic or Square .  Label your tree map with Sales , Category , and Region . From the Data pane: Drag Category to Label on the Marks card.  Drag Sales to Label on the Marks card. Drag Region to Label on the Marks card. Great work! You’ve built a tree map to compare the relative contribution of Regions and Categories for each Region to Sales .