How to display selected record as first in charts?

[#1]

Dear Experts ,

In my chart i am displaying country wise report . whatever be a country selection , i want to display all country record . so i am using set analysis  and making country value as null ({<Country=>})  .

But in my chart my first country details should be a  selected country in a country list box .   for ex my country list box value is dubai , then i want to display dubai country details as first record , rest will display next to dubai country details .

[krishna20]

Hi,

Try this,

Goto Properties of your chart-> sort-> Choose Expression-> COMP_CODE=003(Dubai Company Code).

[sunny_talwar · Accepted solution]

See the attached file to see if this meets your requirement:

When UK is selected -> it is at the top

When USA is selected -> it is at the top

When Dubai is selected -> it is at the top

Used the following sort order -> =Match(Country, $(vVar))

Where vVar is equal to =Chr(39) &Country & Chr(39)

HTH

Best,

Sunny