lost in dimension and expression .. bar chart

[amien]

i have 4 columns as data source. each column is a category.

in 4 bars i want all 4 categories .. and then a sum of it of each catergory.

i now have in dimension all 4 categories .. and then 4x sum in expression.

but this is not really working

[johnw]

I don't think I understand, but maybe this?

Expression1 = sum(category1)
Expression2 = sum(category2)
Expression3 = sum(category3)
Expression4 = sum(category4)
Expression5 = rangesum(Expression1,Expression2,Expression3,Expression4)

Use a combo chart, first four expressions displayed as stacked bars, fifth expression displayed as text on data point and an invisible symbol?

[amien]

what the problems is, that the 4 column have no relation.. i need to group them.

the group will contain 4 items. Then i can put the group in the dimension .. and do a sum(value) in expression. This will give me (i hope) a 4 bar chart.

but how can i group them based on let say column position or column name from excel as source?

[amien]

see example ... i came up with loading the data 4 times ..

[#5]

I'm getting lost in expressions too!!! I have a simple data source. Data are classified as follow: Class, product, sales splitted over three years. I have to calculate Year to date and Moving annual total for every product...I already tried different expressions but they don't work at all? Does anyone know how to do that...

Thanks in advance for your help.

PS: I have Qw personal edition, please make the attached file downloadable to me

Thanks again