No they are in one column. I have forecasts and actual in column A called
"Data Source" and in my pivot table I am grouping forecast and actual along
the header of the pivot table.
"Debra Dalgleish" wrote:
Are Forecast and Actual separate fields in the data area?
pivot table drop down values wrote:
I am trying to insert a calulated item as a %. Columns A includes forecast
and actual values. I want the clauculated item to be % of forecast to actual.
I just relized I am getting a message that says "calculated items do not work
with custom subtotals" I swear it worked once and kept bombing excel.
"Debra Dalgleish" wrote:
What calculation are you creating? Maybe it's something that can be
calculated in the source table, then added as a normal field in the
pivot table.
pivot table drop down values wrote:
I have approx 8000 rows of information with approx 30 columns. I want to add
a custom calculation which I was able to to at first but everytime I refresh
the pivot it bombs out & closes. I am assuming it the file is to large. Is
there a way to fix this?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html