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?

Hi ​@SandyA  If you don’t want the Customer ID to repeat, remove ARTran.RefNbr from the grouping and group only by Customer.AcctCD. This will return one row per customer and produce the expected results. If you need customer-level totals by month, the GI will correctly sum all transactions within the selected period.

​@npetrosov31 

​@jzhu 

​@nickcerri32 

The purpose for report is to get the invoiced sales of each customer for the year.

Since ARinvoice is join to ARTran it is duplicating the customers.

The reason why I joined the ARTran was to t get the GP$ and GP% of each customer as well.

If there is any way to get the GP$ and GP% without join ARTran kindly let me know.

​@npetrosov31 thanks a lot

​@npetrosov31 

Can you shear your RELATIONS FIELD please

​@SandyA 

Here are relations: