5 Replies Latest reply: Jan 12, 2017 4:10 AM by Yeo Poh sai

How to compute Sales By Group Amount only for Top 3 customer ?

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

• Re: How to compute Sales By Group Amount only for Top 3 customer ?

What is you use..

=Sum({<\$(ColumnDim101) = {"=Rank(Sum(sales)) < 4"}>}sales)

• Re: How to compute Sales By Group Amount only for Top 3 customer ?

Hi Sir

The return number wrong, it should not be so much .

• Re: How to compute Sales By Group Amount only for Top 3 customer ?

How the correct value is

Correct value is :-

G1 = 2.673 Billion

G2 = 0.718 Billion

Can you provide example of above?

• Re: How to compute Sales By Group Amount only for Top 3 customer ?

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