Analytics Software

Hello Gurus

I have a report with bar graph and it is placed in the dashboard with two state prompts 1. state prompt 2. state duplicate prompt which is placed next to each other and the bar graph will compare two state values at a time based on the prompt selection. The issue is the customer wants the legend in the order of the prompt place which means currently Legend shows two states now based on the alphabetical order

For example Case 1: From the first state prompt i choose alabama and from the state duplicate prompt i choose california then the legend will show Alabama with blue color and California with red color Case 2: from the first state prompt i choose Colorado and the second state duplicate prompt i choose Alaska now the legend shows me Alaska first in blue and then Colorado in Red but the Customer wants Colorado to be first in blue and then Alaska in red instead i am getting it in alphabetical order. Please advise.

Thanks
RC

Edited by: user1146711 on Sep 7, 2012 12:24 PM

Edited by: user1146711 on Sep 7, 2012 12:25 PM

Edited by: user1146711 on Sep 11, 2012 9:09 AM