Hi,
I just put a pivot together which had values for every day of the month for the last 6 months...
Think of it as the values of 4 or 5 stock prices being tracked on a daily basis over the past 6 months for 5 clients or something...
Once I was done with bringing down the sum of around 180 values, I realized that I need to look at the value field as a percentage of the total... instead of just the sum. Is there a way to change all the values in one go?
Additionally, is there an easier way to do this? as in pulling down multiple values into the values section....
Thanks for any inputs in advance....
Cross Post:
http://www.excelforum.com/excel-gen...section-of-a-pivot.html?p=2829562#post2829562
I just put a pivot together which had values for every day of the month for the last 6 months...
Think of it as the values of 4 or 5 stock prices being tracked on a daily basis over the past 6 months for 5 clients or something...
Once I was done with bringing down the sum of around 180 values, I realized that I need to look at the value field as a percentage of the total... instead of just the sum. Is there a way to change all the values in one go?
Additionally, is there an easier way to do this? as in pulling down multiple values into the values section....
Thanks for any inputs in advance....
Cross Post:
http://www.excelforum.com/excel-gen...section-of-a-pivot.html?p=2829562#post2829562
Last edited:
