| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot Table % calculation
I am getting a div/o error, when i insert a calculation into a pivot table.
How can i leave blank instead of getting the Div/0 error thanks jerry |
|
#2
|
|||
|
|||
|
You can hide the errors:
Right-click on a cell in the pivot table Choose Table Options Add a check mark to 'For error values, show' Leave the text box empty Click OK jerry wrote: I am getting a div/o error, when i insert a calculation into a pivot table. How can i leave blank instead of getting the Div/0 error thanks jerry -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
thanks debra. i actually was able to figure this one out . But thanks for
responding! "Debra Dalgleish" wrote: You can hide the errors: Right-click on a cell in the pivot table Choose Table Options Add a check mark to 'For error values, show' Leave the text box empty Click OK jerry wrote: I am getting a div/o error, when i insert a calculation into a pivot table. How can i leave blank instead of getting the Div/0 error thanks jerry -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Add a Calculation to a Pivot Table ? | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Linear Mode
