6 Replies Latest reply: Jan 11, 2017 5:58 AM by Yeo Poh sai RSS

    Sum(sales)/Sum(TOTAL(sales)) compute all Total customer sales , How to make it compute only Top 3 customer Total ?

    Yeo Poh sai

      Hi All

       

       

      My Table 1 display all customer. it last column display sales contribution % for all customer.

       

       

      My Table 2 display only TOP 3 customer. it last column display sales contribution % for all customer.

       

       

      May i know how to make my Table 2 sales contribution compute only for Top 3. so that the % contribution as below :-

       

       

      =[COMPANY] Sales        Sales % Cum

                            89,344,812 100%

      NOBI PUTRA ANGKASA, PT 34,364,010 38%

      MUHAMAD YASIN 27,769,691 31%

      MANDALA MITRA KARYA, PT 27,211,111 30%

       

       

      My current expression is below :-

       

       

      Sum(sales)/Sum(TOTAL(sales))

       

       

      it should be :-

       

       

      Sum(sales)/Sum(TOTAL(rank<4(sales))

       

       

      But it cannot work , Hope some can advise me.

       

       

      Paul