I have the following pivot table:

                                          Jan               Feb

OFFICE       CLIENT        INCOME       INCOME    

New York     Nike                1                   2

                   Adidas             3                  4

Atlanta        Nike                 5                  6               

                  Adidas              7                  8    

                  ALL                  9                 10

ALL            Nike                 11                12

                  ALL                 13                 14   

ALL (OFFICE) means INCOME not allocated to a specific office.

ALL (CLIENT) means INCOME not allocated to a specific client.

I need to allocate those INCOME.

Can I use a aggregate formula in the pivot? Which formula?

Required result:

CASE 1

now: ALL (OFFICE) + ALL (CLIENT) = 13

calculated: (13 / (1+3+5+7)) * (1) add this portion of the income to New York - Nike,

                 (13 / (1+3+5+7)) * (3) add this portion of the income to New York - Adidas,

                 (13 / (1+3+5+7)) * (5) add this portion of the income to Atlanta - Nike,

                  ...

CASE 2

now: Atlanta (OFFICE) + ALL (CLIENT) = 9

calculated: (9 / (5+7)) * (5) add this portion of the income to Atlanta - Nike,

                 (9 / (5+7)) * (7) add this portion of the income to Atlanta - Adidas,

I am trying the allocate all income and get rid of the ALL categories. I do hope ı was able to explain this. Not much hope for a solution tho.. Thanks!