Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Total Count Values is not Showing For All Same Value

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)

3 Replies
YoussefBelloum
Champion
Champion

Hi,

try to attach the app or sample data

Anonymous
Not applicable
Author

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.

shraddha_g
Partner - Master III
Partner - Master III

in "aggr( count( CT_InvoiceId),CT_CustomerId)" this expression add all other Dimensions present in table