Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
BI_Dev
Creator II
Creator II

Total by each ID

Hi  - I have data as below 

ID Mth_Year Sales Total Sales
ABC Feb-2023 $706 $1,412
ABC Jan-2023 $706 $1,412
DEF Feb-2023 $706 $1,412
DEF Jan-2023 $706 $1,412
GHI Feb-2023 $1,656 $3,311
GHI Jan-2023 $1,656 $3,311
JKL Feb-2023 $1,229 $2,459
JKL Jan-2023 $1,229 $2,459

 

Total sales is a new column, that I need to create and I nee dthe total of sales by each ID...

Tried sum(total <ID> Sales) but this doesnt work..any thoughts please.

 

Thank you so much.

 

Labels (5)
2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

"sum(total <ID> Sales)" should work. What result did you get when you tried that?

Is "Sales" a field or a Measure Name?

-Rob

Ahidhar
Creator III
Creator III

is this the desired output ,then sum(total<ID>Sales ) is working