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

[paulyeo11]

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

[paulyeo11]

my qvw

[MindaugasBacius]

Use Dimension Limits in Chart properties:

[paulyeo11]

Hi Mind

Thank you for your reply. ( I am using ver 9 )

I can limit the top 3 customer ,

Now i present in Table , i need to know how to  change the expression .

below only compute Top 3.

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

Paul

[MindaugasBacius]

The first expression:

If(Aggr ( Rank ( Sum(sales)/Sum(TOTAL(sales))) , Customer ) <= 5, money(Sum(sales)/$(Columndim89),$(vMoneyFormatK)))

The second one:

If(Aggr ( Rank ( Sum(sales)/Sum(TOTAL(sales))) , Customer ) <= 5, Sum(sales)/Sum(TOTAL(sales)))

[sunny_talwar · Accepted solution]

This?

Expressions

money(Sum({<$(ColumnDim101) = {"=Rank(Sum(sales)) < 4"}>}sales),$(vMoneyFormatK))

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

[paulyeo11]

Hi Sunny

Your expression very powerful , Thank you very much it work fine.

Paul