need formula for tricky output

[Anonymous]

Dear All,

Need some help Please find the attachment with expected output.

Thanks

[PrashantSangle]

Hi,

What is your expression for contr???

try below logic

sum(ContriExpression)/Sum(Total <ST> ContriExpression) * 100

Regards

[Anonymous]

I used (SUM(Sale)/ SUM(TOTAL(Sale)))*100

But using above I am not get expected output

[kamal_sanguri]

use below expression:

(sum(Sale)/sum(total <ST>Sale))*100

[kamal_sanguri]

here is the updated qvw

[PrashantSangle]

Hi,

try like

(SUM(Sale)/ SUM(TOTAL<ST> Sale))*100

Regards

[kamal_sanguri]

or you can use :

(sum(Sale)/aggr(nodistinct sum(Sale),ST))*100

[Anonymous]

Hi Kamal,

in the attachment for ST contribution is missing (71.1 and 28.9)

Please see ex op excel.

Thanks

[settu_periasamy]

Try this ..

=if(Dimensionality()<=3,SUM(Sale)/ SUM(TOTAL(Sale))*100,
sum(Sale)/sum(total <ST>Sale)*100)

[kamal_sanguri]

what you want to see is the percentage distribution and the sum of percentage distribution will be equal to hundred.

for ex:

Item Share %dist

a       30     30%

b      40      40%

c      30     30%

subtotal - 100%