Custom Calculations

  • Thread starter pivot table drop down values
  • Start date
P

pivot table drop down values

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?
 
D

Debra Dalgleish

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.
 
P

pivot table drop down values

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.
 
P

pivot table drop down values

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.
 
D

Debra Dalgleish

Instead of a calculated item, you could add the amount to the data area
again.
Right-click on the heading for the second amount, and choose Field Settings
Click the Options button, and for Show Data as, choose % of
For Base Field, choose Status
For Base Item, choose Forecast, click OK

There's an example here:
http://www.contextures.com/xlPivot10.html

This will show columns for Actual and Forecast, and you could manually
hide the one you don't want.
 
P

pivot table drop down values

Thanks that works very nicely! As a work around I was inserting the
calculations to the right of the pivot but of course if my users deselected a
value or modified in anyway it would screw up the manual calculations.
Thanks again for being so responsive. You have been an tremendous help
 
D

Debra Dalgleish

You're welcome. Glad I could help.
Thanks that works very nicely! As a work around I was inserting the
calculations to the right of the pivot but of course if my users deselected a
value or modified in anyway it would screw up the manual calculations.
Thanks again for being so responsive. You have been an tremendous help


:
Click to expand...
 
Top