Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Maybe you could try this one.
Regards,
Janzen
Hai ,
I am attaching the same file of Janzen with little modifications.
It may helps you ,Please find it
Thanks ,
Rathish
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.