[vkober]

Hi,

in the joined file...
I want to display the sum of all the series at the right end of the bar :
For example : 184,04 for the Diamond T620 Se... line, sum of 68,29 and 115,75 )

I dont find a solution for that...have I to add an invisible serie with the sum ? put a script to do that ?

thanks in advance for your answer

Vincent

Attached File(s)

•  chartwithtotalseries.rptdesign (176.69K)
  Number of downloads: 8

[mwilliams]

Do you want the individual series labels as well? Or just the total?

[vkober]

Hi
In this case I just want the total but why this question ? It is not the same way to produce the report with or not the total ?
Regards

Vincent

[mwilliams]

The reason for the question is that if you're already using the series labels to display each series value, you won't be able to use the original series labels to put the total. If you're not using the series labels, you'd just make the top series label be "outside" the bar, and compute the total and use script to change the label value. If you had been wanting to show the individual series values, too, one way would be to use a couple extra series, like you said above. Let me know if you have questions or would like an example.

[vkober]

Thanks Michael
If you have, I'm effectively interested by an example about summing the individual value and use script to change the label. I won't use the individual values.
Best Regards

[mwilliams]

Sorry for the delay. Take a look at this edited version of your report. The only place you need to look is in the chart script. Hope this helps.

Attached File(s)

•  chartwithtotalseries(1).rptdesign (177.39K)
  Number of downloads: 9

[vkober]

Hi Michael
Sorry but I cannot try before next week.
I will give you a feedback.

Best regards

[mwilliams]

Sounds good. Just let me know if there are issues.

[vkober]

Hi Michael

I had still few problems with this topic... essentially on rounding summing float values..
Resolved in the joined example...
Another problem, resolved with my idea but perhaps there is another way...if you have an idea ?
When the last series is equal to 0, the sum is not display (in the example : 1958 Setra Bus)
So my idea is to put a 0.000001 value (by computed column or another way) in this case (in the example : 1957 Chevy Pickup)

hope this example will be helpfull for another

Regards

Vincent

Attached File(s)

•  chartwithtotalseries(31).rptdesign (184.11K)
  Number of downloads: 3

[mwilliams]

Your computed column idea is what I had done in the case that you had wanted the individual series values to show, too. So, you're right on track with what I would have done.