Calculate Contribution per Area

[Anonymous]

Hi,

I have a question about calculate contribution.

I have a pivot table like this

                                    Week            W1                   W2                    W3 

Area1          Area2        Area3

A                   A2           A3               5                       10                    15 

                                     A4               6                        20                    20 

                                     A5               3                         10                    5

                      A6           A7               1                         1                      1

                                     A8               2                          5                     6

B                    B1          B2               1                          1                    20

                                    B3                5                         5                    20

                                    B4               1                         1                       1

I want to calculate contribution each area per week.

example for A|A2|A3 the quantity for that area is 5. So the contribution must be 5 (qty A|A2|A3) divided by total quantity of Week W1 (5+6+3+1+2+1+5+1)--> every area

So the result will be 5/24 = 0.20

Anybody has idea ?

Really appreciate your help

Thanks

[tresesco]

May be like:

Sum(Quantity) / Sum(Total Quantity)

[jagan · Accepted solution]

Hi,

Try like this

Sum(Quantity) / Sum(Total <Week> Quantity)

Regards,

Jagan.

[Anonymous]

Hi All,

Thanks for your idea.

You both are great.

Thanks in advance