how to grouping 2 data field

Hi, can you share your Generic Inquiry here so we can test and troubleshoot? What is the desired outcome of this GI? To have one line of record for each customer or for each transaction? 

​@SandyA What exactly should the output look like?  You’re grouping by Customer and Reference Number, so if there are multiple reference numbers per customer, you’ll see the Customer record duplicated that many times.  Also, I typically have the detail table set as the parent table.  If you’re using the in-built joins, it’ll look like this.  However, this alone won't solve your problem.  Let me know what you’re trying to achieve and I can get you a better response

This is the GI that I have built. My outcome will be monthly report. and I don't what the customers ID to be repeating like this

Hello,

Do you actually need that grouping by the RefNbr? It looks like to be the problem why you get so many records. Add the RefNbr field to the results grid, I think you will get it different for each line. What is the purpose of grouping by it?