Summarize dimension columns

[#1]

Hi!

I'm trying to summarize columns which represent a dimenion. I want to create a chart that looks somewhat like this:

Salesman	Monday	Tuesday	Wednesday	Thursday	Friday	Total
Elvis Presley	4	3	1	0	4	12
Don Draper	1	2	3	4	0	10

I've succeeded with everything but the Total-column.

My problem is that the weekdays are a dimension which I moved so that it would show as columns. I therefore only have one expression, the sum of sales. Which then gives me the sum for each salesman every day day. But I can't figure out how to at an extra column with "Total".

Any suggestions?

[#2]

i attach a vd see.

REGARDS

[#3]

Thanks for your reply

I dont really understand how your example would help me. I have a sum expressions which sums up the sales for each salesman and then presents it per weekday. I would then like to add a column which would summarize all the other columns. So regardless if I choose to see only 2 days or the whole week, I would see the totalt of all the columns which are visible.

[perumal_41]

Hi,

I have attached one application, this solved ur problem

[#5]

I finally figured out how to solve it. in the Style-tab i unchecked the box "indent". This then gave me the oppertunity to check the "partial sum" box for my "weekday"-dimension which was greyed out before. I then checked the indent-box again and it works