Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone
I have two tables; Customer & Invoice
Customer table has 1000 records like this
CustomerId | CustomerName |
---|---|
1 | A |
2 | B |
3 | C |
4 | D |
5 | E |
Invoice Table contains 100 records like this
InvoiceId | CustomerId | Amount |
---|---|---|
1 | 1 | 1000 |
2 | 3 | 500 |
3 | 5 | 600 |
4 | 1 | 200 |
5 | 1 | 100 |
6 | 3 | 600 |
I want all 100 records from Invoice table like this
CustomerId | CustomerName | InvoiceCount | TotalAmount |
---|---|---|---|
1 | A | 3 | 1300 |
3 | C | 2 | 1100 |
5 | E | 1 | 600 |
PFA,
maybe this:
for InvoiceCount = Count( InvoiceId )
for TotalAmount = Sum( Amount )
Hi,
Customer & Invoice both are connected by CustomerId.
Then use the straight table :
Dimension : CustomerId ,CustomerName
Expression : Count(InvoiceId) //Count(Distinct InvoiceId)
Expression : Sum(Amount)
Thanks,
Mukram
Thank You
This shows what I exactly needed
Thank You Mohammed