I’m working on a complex dashboard where I have several If-Then scenarios coming from demand consumption. The dashboard is pulling information from Job Demand and Issued figures, On-Hand demand, and Open PO Lines. In a case where the demand is satisfied in the job, I don’t want it to show the On-Hand, nor PO information. If it’s still an open line item and is Satisfied by On-Hand Material then I don’t want it to show the Open POs for that part. I also need to tackle the issue that if there is more than one On-Hand location and/or multiple POs that it not duplicate the demand figures in each line. Is there a way to either tackle this kind of logic in the BAQ output or the Dashboard information? I would prefer to show a single line for the demand and and supply portions (skipping what is not needed) and be able to drill down into the detail as needed.