Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
My Table 1 Expression display whole of last sales is correct :-
Money(
Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = >} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)
,$(vMoneyFormatK))
On the next column , i need to display only Top 3 customer sales amount , so i use the expression given by sunny as below :-
Sum(TOTAL {<$(ColumnDim101) = {"=Rank(Sum(sales)) < 4"}>}sales)
it return All 10,644,1876 which is wrong value.
Correct value is :-
G1 = 2.673 Billion
G2 = 0.718 Billion
Paul Yeo
My QVW
What is you use..
=Sum({<$(ColumnDim101) = {"=Rank(Sum(sales)) < 4"}>}sales)
Hi Sir
The return number wrong, it should not be so much .
How the correct value is
Correct value is :-
G1 = 2.673 Billion
G2 = 0.718 Billion
Can you provide example of above?
Hi Sir
When you Click on G1 Button , it will show the top 3 customer sales for G1 , when you add up the 3 row total it will be the total i need.
Paul