5 Replies Latest reply: Jan 12, 2017 4:10 AM by PAUL YEO RSS

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

    PAUL YEO

      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