In Bar graph show the Pop Up Message

[Ramu]

Hi All,

Please help me ,

1. Scenario 1:

I have Bar char , in that country is the dimension and sum(sales) is my measure, in that having country wise sales information. Whenever mouse is placed on bar ,pop up is displaying.

I tried this code to display that one 

Dual(City & Chr(10)&'Product Codes :'&Chr(10)&

Concat(DISTINCT Product ,Chr(10))& Chr(10)&

'% Gain='& Num((Sum(Sales)/Sum(Total Sales))*100 ,'##,#0.##')& '%' &chr(10)&
'Total Sales=' & Sum(Sales),Sum(Sales))

displaying the pop up is 

Country =USA

City=New york

Product:

101

102

103

% Gain =20 %

Total Sales  = 10100

But I want to display in this way.

Country =USA

City=New york

Product:

101 ---4400 ---43.56 %

102 ---4770 ---47.22 %

103 ---930 ---9.2 %

% Gain =20 %

Total Sales  = 10100

2.Scenario 2:

I have ID field, P_ID , M1...M5 Values (Yes, No) are there,

based on Id which is max count of yes in M1... M5 Tables,

i used rangemax( M1...M5 ) it will display the value, 

But I want to display the column name also Like 

ID      MAX Value     Field

101      15                  M1

102      10                  M1

ID	Max Value	Field
	25
101	15	M1
102	10	M1

I attached QVW file , Please help me .

Thanks  

[rubenmarin · Accepted solution]

Hi, for scenario 1 you can use:

Dual(City & Chr(10)&'Product Codes :'&Chr(10)&
Concat(Aggr(Product & ' --- ' & Sum(Sales) & ' --- ' & Num(Sum(Sales)/Sum(TOTAL <City> Sales),'#.00%') , City, Product) ,Chr(10))& Chr(10)&
'% Gain='& Num((Sum(Sales)/Sum(Total Sales))*100 ,'##,#0.##')& '%' &chr(10)&
'Total Sales='  &  Sum(Sales),Sum(Sales))

 For scenario 2 I can only think on a nested if comparison, maybe there is a clever way than this.

Sample attached.

[Ramu · Accepted solution]

Hi Rubenmarin,

Thanks for your valuable suggestion.

It's working.

Thanks a Lot.