Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi Rubenmarin,
Thanks for your valuable suggestion.
It's working.
Thanks a Lot.
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.
Hi Rubenmarin,
Thanks for your valuable suggestion.
It's working.
Thanks a Lot.