Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I am creating an expression which will give me the total no of column1 present for customer like if i have 3 invoice for one customer it should show 3 for all the customer but now im able to get only in one row.
Can you please help me out on the same?
Expression:aggr( count( CT_InvoiceId),CT_CustomerId)
Hi,
try to attach the app or sample data
In the Image you can see, there are 3 rows and has the same customer and whenever im doing the aggr(count(ctinoiceid),customerid) then it shows 3 rows which is right but its showing in 2nd rows, but i want in all rows.
in "aggr( count( CT_InvoiceId),CT_CustomerId)" this expression add all other Dimensions present in table