Report to loop through Sales People that have Sales in the selected period (and ignore those that don't).
I am trying to create a report using the application automation to be emailed to all the Sales People that have sales in a given month.
I have tried to do this by creating a report, then adding the sheets required and then adding a selection to the report for the current year and month (using the get variable block to collect the current year and month from the app).
The challenge I am having is how to only loop through the Sales People that have sales for that period.
If I use the "List values of Field" block or the Get Straight table block these both seem to ignore the selections I have placed on the report so I can only get a list of all the Sales People rather than just those with Sales for the period selected.
Am I right in thinking that the add selection to report does not affect those blocks? If so is there a way to return a list of only the sales people with sales in the current year and month so that I can then use that list to loop through and select each sales person for sending out the emails? Essentially I want to return a list of the possible values from the Sales Person field once the year and month selections are in place?
Update: I managed to acheive this by adding a straight table into the app that had the required filtering (sales year and month) and Sales Person name so that I could use that and the get straight table block for my list.
I suspect there is a better way so I would still appreciate further comments because I don't really want to clutter the app up with straight tables which I will have to doing things this way.