Sorting value in Line chart

[Anonymous]

Hello All,

I am preparing a Line where my Dimensions are State and month. In the line chart, I am trying to represent the accident reported in each month from all state. In the line chart, I am showing Top file states having more accidents each month.

State   Month     Accident Count     %

A        Jan'15         100                                

A        Feb'15         150

A        Mar'15         140

B        Jan'15          80                 

B        Feb'15         100

B        Mar'15         110

B        Jan'15         180                 

B        Feb'15         110

B        Mar'15         140

Percentage calculation will happen accident reported each month for each state/total accident reported. I want to my Line chart to show top 5 states having highest accident on a monthly basis but the value which will represent on the chart would be % of accident.

In short, top 5 states having highest accident count month on month.

Hope i explained it well.

Thanks in advance.

Regards,

Imran Khan

[jduenyas]

Set the state to be the first dimension.

In the Sort tab /Sort By, check the box "Y Value".

In the Presentation tab, check the Maximum Visible Number and enter 5 next to it.

Hope this helps if I understood it correctly.

[ecolomer]

See this example

[ecolomer]

Or this: