3 Replies Latest reply: Oct 11, 2012 12:26 PM by Pritam Dey

# Calculating from dynamic columns in pivot view

Hi,

I am trying to use pivot view to get a report in a desired format.

Initial Pivot Table:

Name                ||      Date      ||      Value

A                            1 Oct                    40

2 Oct                    20

3 Oct                    50

B                            1 Oct                    30

2 Oct                    10

3 Oct                    60

I pull the date above to the columns to have a view like this:

Name Date      1 Oct     2 Oct     3 Oct

A                    40          20          50

B                    30          10          60

How do I get an % with respect to total value of the names for that date, i.e when name is A and date 1st Oct the desired value is 40/(40+30) = 0.5714

A on 2nd Oct =  20/(20+10) = 0.66

• ###### Re: Calculating from dynamic columns in pivot view

Hi,

Maybe you could try this one.

Regards,

Janzen

• ###### Re: Calculating from dynamic columns in pivot view

Hai ,

I am attaching the same file of Janzen with little modifications.

It may helps you ,Please find it

Thanks ,

Rathish

• ###### Re: Calculating from dynamic columns in pivot view

Thanks, This definitely helps.

The only thing which I am stuck with is to get a generic function out of it because I have several such names and dates (i.e Names: A,B,C,D,E.... and so on Dates: 1st Oct, 2nd Oct, 3rd Oct, 4th Oct... and so on).

What I am trying to build is a date wise percentage aggregator.