Display sum value for multiple series

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

Find more posts tagged with

Comments

mwilliams

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

Migrateduser

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.

Migrateduser

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.

Migrateduser

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.

Migrateduser

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

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.