Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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
Hi,
Try this,
Goto Properties of your chart-> sort-> Choose Expression-> COMP_CODE=003(Dubai Company Code).
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