Total line on a chart

[#1]

Hi,

I've realized a line chart with one dimension and one expression.
The chart rapresents the amount of sales of each branch...but I would like to show in the same chart a line that rapresents the total amount of sales of all branches.

It's possibile to realize ?
How can I do ?

Thanks a lot.

[#2]

Hi,

check the attached image. Like wise you want to show a line (total sales of all branches) along with the sales of individual branches.

Let me know if my understanding is correct or wrong.

-Raghu

[#3]

Exactly what I mean!

How can I realize this ?

Thanks a lot

[#4]

go to "EXPRESSION" tab, select full accumulation at the bottom

then go to "PRESENTATION" tab Add an expression in the Reference lines like Sum(Salesamount).

try this and let me know

Thanks

Raghu.

[#5]

I have found the "Full accumulation" but I can't understand where I have to add an expression in the Presentation tab.
In the Presentation tab I can only some properties of the chart like borders, colors, etc....

Maybe I haven't understood correctly.

I have even try to create another expression and set it as "Full accumulation" but the chart is unreadable.

Can you explain me again ?

Thanks a lot.

[#6]

look at the attached image. If this will not works fine can you upload your document to me.

-Raghu

[sathishkumar_go]

Hi Syead,

Go for Presentation Tab --> Numbers on Data point

select Vertcal

thats it

Raghu I don't think so for reference lines is correct for this option

-Sathish

[sathishkumar_go]

oh sorry raghu

wrongly i send my previous post

[#9]

It works...but I think the line isn' correct.

It is an horizontal and constant line on the top, like if it's a fixed value.
Instead, what I would like to see is a line near the lines detail so I can show how each branch follow or not the total line.

Can you understand me ?

Thanks

[#10]

Hi,

Check the attached application.

- Sridhar