- Open a blank worksheet and drag and drop Gender from Dimensions into the Columns shelf.
- Drag and drop Number of Records from Measures to the Rows shelf.
- Drag and drop Aware of recycling possibility from Dimensions to Color in the Marks card.
- Hover over the Number of Records pill in the Rows shelf so that a small downward arrow appears and click on it.
- Navigate to Quick Table Calculation | Percent of Total. Choose the Edit Table Calculation... option and select Table (down).
- Press Ctrl and drag and drop Number of Records from Rows to Label in the Marks card.
- Click on the Sheet 4 tab at the bottom of the page and enter Awareness by Gender:
As we can see in the preceding screenshot, among females there are more buyers who ...