1 - How can I include the count in Row 9, where the '-' represents the count? Please refer to the attached Excel file, which shows the outcome displaying a numerical count.
2. Highlight the cells in Row 9 that are not 0 in yellow?
1) Calculate the counts and output directly to that range
2) Conditional formatting in Alteryx is only done with rules in the Table tool - instead can you output the data to Alteryx and "preserve formatting" so the conditional formatting happens in Excel instead?
