Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have one table with two fields relating to the same table.
First table is called Invoice with the following colums:
Second is a customer table with the folowing colums:
This is very simplified example but the issue is the same. From_Customer and To_Customer shoulde relate to the Customers table.
In my QVW i have a chart where i want to display Income and Cost, obviusly the Income amount and Cost Total shoulde be equal when all customers are selected.
When i select one or more customers i want to see if i have more income than cost.
I hope it makes more seen if you view the QVW i have provided as an Attachment.
Invoice:
InvoiceID,
From_customer,
To_Customer,
Amount
FROM Invoice;
customer :
LOAD
CustomerID AS From_customer,
CustomerID AS To_Customer,
Name
FROM customer;
Invoice:
InvoiceID,
From_customer,
To_Customer,
Amount
FROM Invoice;
customer :
LOAD
CustomerID AS From_customer,
CustomerID AS To_Customer,
Name
FROM customer;
This fixed the issue in regard to the two colums related to the same tabel, thanks. No i have to figure out out to count the Income vs Cost. Thanks for the help.