Using Aggr

[marishnagendran]

Hi All,

PFA File.

In That Customer name is my dimension.For measure i want to take invoice amount.

In that table structure we are maintaining history but in front end i want to take calculate one invoice amount i.e(1500)

Dimension is Customer_Name

I'm using expression as

Aggr(Sum(Invoice Amount),Trx_ID)

But its not working

My Scenario is Based on Trx_ID i want to calculate invoice amount my dimension is Customer Name

[sunny_talwar]

Not sure I understand completely, but may be you need this

Sum(Aggr([Invoice Amount], Trx_ID)

[marishnagendran]

Every day we are maintains invoice table history.

For Example, I'm taking one customer invoice id i.e(Trx_ID)

Customer Name	Trx_ID	Invoice Amount	Load Date
A	123	1500	01-Apr-19
A	123	1500	02-Apr-19
A	123	1500	03-Apr-19
A	123	1500	04-Apr-19
A	123	1500	05-Apr-19
A	123	1500	06-Apr-19

The customer bought one time only but we are maintaining history so the records are repeating

Now i want to sum the invoice amount based on customer name.

I need a output like 

For A customer the invoice amount is 1500

[sunny_talwar · Accepted solution]

Did you give this a shot... missed an additional closing parenthesis at the end....

Sum(Aggr([Invoice Amount], Trx_ID))

[marishnagendran]

Thank you its working