T
Ted Claypool
Hi All.
I am creating a pivot table of financial data and am
running into a problem I can't find any help for.
When working with the finincial data - I use a "sum of
value" to calculate quarterly and yearly finincial data
items - this works great!
I also have "calculated Items" where I calculate values
based on the sum of value - like Total Revenue. This
works great too!
When I want to calculate percentages (like total costs /
total revenue) - I'm having a problem with the value that
is returned in my yearly total. The value returned is a
sum of all quarterly totals rather than an average of
quarterly totals.
So the question is - is there a way to define a custom
summary calculation so everything is "sum of value" except
for the percentages which are averages of the quarterly
percentages?
If so, what is the method for defining this
custom "calculated field" for the specific item(s).
Thanks much!
I am creating a pivot table of financial data and am
running into a problem I can't find any help for.
When working with the finincial data - I use a "sum of
value" to calculate quarterly and yearly finincial data
items - this works great!
I also have "calculated Items" where I calculate values
based on the sum of value - like Total Revenue. This
works great too!
When I want to calculate percentages (like total costs /
total revenue) - I'm having a problem with the value that
is returned in my yearly total. The value returned is a
sum of all quarterly totals rather than an average of
quarterly totals.
So the question is - is there a way to define a custom
summary calculation so everything is "sum of value" except
for the percentages which are averages of the quarterly
percentages?
If so, what is the method for defining this
custom "calculated field" for the specific item(s).
Thanks much!