I am working on a custom label and I have three datasets. The first one, ReportData is where all the pertinent info lives. However, they wanted me to add in Total Bin Qty for each shown bin. No problem, so I created a third dataset for this simple query. Now I am trying to use the ReportData dataset Part, Warehouse, and BinNum to restrict the third dataset. I am getting an aggregate can’t be used for filters. Ideas on how to move forward?
You might be better off re-writing that additional dataset as a subquery in your ReportData DS and then aggregating it within the SQ and then join to your existing query on Part, Warehouse, and Bin.
1 Like
Yeah, I was hoping not to do so. Would take much longer. It’s a query written before me and is fairly complicated.