Total in Line Chart

[gajapathy74]

Hi,

Is there a way, we could draw total line in the line chart.

Assuming I have a LINE chart which should have line per branch with the following.

X-Axis -- Month

Y-Axis -- Sales

In this chart I wanted to display a Total LINE in addition to the existing lines.

I have attached sample QVW file for ready reference.

Thanks in advance.

[#2]

One way is to build a Branch called 'Total' in the script.

Temp:

LOAD * INLINE [

Month, Branch, Sales

Jan, A, 500

Jan, B, 450

Jan, C, 475

Feb, A, 480

Feb, B, 465

Feb, C, 480

Mar, A, 490

Mar, B, 470

Mar, C, 480

];

Concatenate (Temp)

Load Month,

'Total' as Branch,

sum(Sales) as Sales

Resident Temp

Group by Month;

[gajapathy74]

Hi Ben,

Thank you for your quick reply. We can't use concatenate load to get branch total, because we have other filters like country, sales rep, etc, which will determine the data that needs to be plotted branch wise.

I have checked few post in the forums and most of the response I seen there is to go with mix of bar chart and line chart, which I don't want to.

Please let me know if you have any other alternate.

Regards,

[#4]

Hi,

see the example for more details.

Good luck!

Rainer

[gajapathy74]

Hi Rainer Filoda,

Thank you for your effort. I have checked the file uploaded by you and found that it is displaying the total across month, branch. Is there a way I can draw a line which shows the total line on a monthly basis.

Please find attached the image for your reference.

Regards,

[#6]

Here's one way.

Tom

[gajapathy74]

Hi Tom,

Thank you for your post. This would be OK if I have only branch filter. But as I mentioned earlier post, I have other filters like Country, Sales Rep., Year, Month, etc. This sample file uploaded here is to give some idea, but originally I am loading the data from a database. All the filters are driven by a user choice and based on the selection I need to show the detail at run time.

Please let me know if you need further information.

Regards,

[#8]

Hi all

I m also having the same problem for the last two months....

Could anyone help me...

we r not having only company,we also have subsector,sector....

thanks and regards

Gopinathan

[#9]

Hi All,

I'm also looking for the same. but still no solution yet.

The alternative:

i'm using is SET. Have a look at the attached. You will need to remove branch from dimension.

Then, in the expression, you do SET to detect each branch. the IF statement in front, is for cosmetic, so when user select one branch, it will show the total with the branch only. instead of showing all, to reduce the data on the screen.

This is not a good solution when you have a thousand branches.... You get the idea....

until then, i'm still looking if there's any ways to put branch in dimension, and without changing the data, we have the total lines.