Hi
can someone advise how to execute a calculation over a subset of rows only?
In my case, I have a table that lists customers and their individual sales. I need a dynamic measure that loops over each customer, and adds their sales to give a total figure.
Example -
Customer, Sale, Total Sale
Jane, 1, 10
Fred, 2, 3
Tom, 1, 1
Jane, 9, 10
Fred, 1,3
I need a measure not a calculated column.
Thanks
can someone advise how to execute a calculation over a subset of rows only?
In my case, I have a table that lists customers and their individual sales. I need a dynamic measure that loops over each customer, and adds their sales to give a total figure.
Example -
Customer, Sale, Total Sale
Jane, 1, 10
Fred, 2, 3
Tom, 1, 1
Jane, 9, 10
Fred, 1,3
I need a measure not a calculated column.
Thanks