There are two ways to create a Dynamic Report:
If you are creating an Advanced report, you may find it easier to first create an SPC or DMS report with retrieval settings that are similar to the desired outcome, and then copy that initial report to an Advanced report.