1. 18 people meet both conditions, and 328 have profits >= $2000 ---> 5.49%
2. South Region
The attached workbook shows my work. You do not need so many calculated fields for #1 but I wanted to demonstrate each step I took.
2.17 Forum question.twbx 1.5 MB
Is there any shortcut way to achieve query 1 using sets may be please suggest