Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Did you give this a shot... missed an additional closing parenthesis at the end....
Sum(Aggr([Invoice Amount], Trx_ID))
Not sure I understand completely, but may be you need this
Sum(Aggr([Invoice Amount], Trx_ID)
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
Did you give this a shot... missed an additional closing parenthesis at the end....
Sum(Aggr([Invoice Amount], Trx_ID))
Thank you its working