How to count number of transactions in table

[Shahzad_Ahsan]

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

[shraddha_g · Accepted solution]

PFA,

[agigliotti]

maybe this:

for InvoiceCount = Count( InvoiceId )

for TotalAmount = Sum( Amount )

[mdmukramali]

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

[Shahzad_Ahsan]

Thank You

This shows what I exactly needed

[Shahzad_Ahsan]

Thank You Mohammed