How to do it…

  1. Open a blank worksheet and drag and drop Age from Dimensions into the Column shelf.
  2. Drag and drop Milk cartons disposal from Dimensions into the Column shelf, to the right of the Age pill.
  3. Drag and drop Number of Records from Measures into the Rows shelf.
  4. Drag and drop Aware of recycling possibility from Dimensions to Color in the Marks card.
  5. Hover over the Number of Records pill in the Marks card so that a small downward arrow appears and click on it.
  6. Navigate to Quick table calculation | Percent of Total. Then, choose Edit Table Calculations and click on Table (down).
  7. Press Ctrl and drag and drop Milk cartons disposal from Column into the Filters shelf.
  8. Deselect the box in front of the Recycling garbage can and click OK.
  9. Press Ctrl and drag and drop Number of records from Rows into the Label in the Marks card.
  10. Click on the Sheet 7 tab at the bottom of the page and enter Potential for recycling: