I have a report that works, but I want it to look differently.
Right now, the report groups the data by part number, priority, then PO#.
For each part number, it has the priority grouped, then it shows all PO#s. Then it shows the next priority for that part number, if it exists. Otherwise it moves to the next part number.
What I want it to have it list all of the priority's then list the PO#s.
How do I make it put the prioritys together then list the PO#s like in the photo that I attached to this post?