Percentage Line Chart usage

[#1]

Hello Comunity. I have a task to create a chart which shows Total, Downloads , Uploads where Total = Downloads + Uploads in scale of month. Total of Items as are shown as 100% staraight line in chart , Downloads and Uploads are other 2 series to show as percentage ( Downloads +Uploads = 100%). So e.g. we have 3 mont Apr: Downloads:11 , Uploads:45 , May : Downloads:10 , Uploads:90 ...

The problem is that Percentage Line Chart is useless for that as it works correctly only if i use Total + Downloads, Total + Uploads in separate Charts.

I find out that what is done: if to place Downloads, Uploads, Total in order we have next: Downloads % = Downloads / (Downloads + Uploads+Total) ; Uploads% = (Downloads +Uploads) / (Downloads + Uploads+Total)

Anyone knows how to split two charts into one ???

Thank's Ruslan

[Former Member]

Dont summarize option is disabled , i mean is gray so no such option. That's more a question to the people who add that charts to designer . Is it suppose to work with 2 series at all??

Than's for you try.

[Former Member]

Don't summarize is gray because it only works on formulas and is designed for formulas which have already been summarised.

what I am recommending is that you get the numbers(percentages) calculated in formulas at the group level ( for the on change of axis )

then use these formulars ( then the button will not be grayed out).

the trick is getting the formulas, but start with group sum formulas for the three columns and then another set to do the percentage