distiction and summerize

[#1]

My goal is always enable to summerize the total hour by using the code sum(working hour) in the expressen after you have made a filtration of distincting CustomerID. In other word, make a distinction of the CustomerID and then summerize the working hour in the expressen. Everything should take place in the chart to display visual statistic. How shall I do it? Is it possible?

Table customer with fields:

CustomerID

first name

last name

city

working hour

// fullmetalboy

[swuehl]

Hi Jimmy,

hope I got it correctly, I think what you need is to create e.g. a straight table chart object with dimension CustomerID

and expression

=sum(working hour)

You could of course change the chart object to e.g. bar chart or soemthing else.

Hope this helps,

Stefan

[#3]

here is the attach excel sheet and qvw file based on you query. I think it solves your problem.