Display Rank as Pop Up?

[#1]

How can i display Top 3 values for a particular field in pop up for all the bars in that barchart.

Detail:

I have created a bar chart with following dimensions and measure:

Country and Value

Now in pop up for all the countries I want to display top 3 countries with highest value i.e. if top 3 countries by value are USA, UK, Japan.... even for Brazil it should show USA, UK, Japan in order ... for all countries.

[#2]

Hi Kushal,

Can we connect via email for this please if possible?

Thanks,

Tanmay

[Kushal_Chawda]

see this below which is back end solution.

Data:

LOAD * Inline [

Country,Sales,Divison

US,300,Finance

US,170,Defence

UK,250,Finance

UK,150,Defence

JAPAN,210,Finance

JAPAN,140,Defence

BRAZIL,220,Finance

BRAZIL,160,Defence

INDIA,230,Finance

INDIA,130,Defence];

New:

LOAD *

Where Sort<=3;

LOAD Country as Top3Contry,

          Divison,

          Sum(Sales) as Top3CountrySales,

          autonumber(Sum(Sales),Divison) as Sort

Resident Data

Group by Country,Divison

Order by Sales desc;

LET vPopUpBackend = Peek('Popup',0,'New');

Popup expression would be

=dual(chr(10)&'Top 3 Sales'&chr(10)&Concat(Top3Contry&' : '&Top3CountrySales,chr(10),Sort),Sum(Sales))

[Kushal_Chawda]

You can mark the above answer as helpful