Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Can we Edit Formula in Calculated Field in Pivot Table ?

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 14-05-2011
Member
 
Join Date: May 2011
Posts: 48
Can we Edit Formula in Calculated Field in Pivot Table ?
  

Hi, I am using the Microsoft office 2007, in which I have to work lot on the Microsoft excel, so many time I have to make some changes in the formula for the calculated fields in the pivot table, so how can I edit It, as I want to include the ISERROR in a calculated field within a pivot table, as I was trying to this by editing the formula in the tab that is generated when we select to list all the formulas from the tools section. Any suggestion?

Reply With Quote
  #2  
Old 14-05-2011
Member
 
Join Date: Jun 2009
Posts: 1,518
re: Can we Edit Formula in Calculated Field in Pivot Table ?

Well, the problem is regarding a formula, you can get the help from the help section provided by the Microsoft, in that they have mentioned the solution for each of the query as far as I know, I always use to use it, as the solution is also provided in such a manner that any beginner can solve their problem. So I would like to recommend you to use those solutions, but if you didn?t found any answer to your query you can have the another option too for online support.
Reply With Quote
  #3  
Old 14-05-2011
Member
 
Join Date: Nov 2008
Posts: 1,514
re: Can we Edit Formula in Calculated Field in Pivot Table ?

Yeah, you can use that function in the excel, as you are using it , you must be aware about what it does, it check whether the particular cell causes any error or not? You can use it by typing IsError( value ), value will be the cell number. And when you enter some value it will give the result in the form, whether the value is true or false. So you can change the values that represent the false values,
Reply With Quote
  #4  
Old 14-05-2011
Member
 
Join Date: Mar 2009
Posts: 1,360
re: Can we Edit Formula in Calculated Field in Pivot Table ?

As you are working on the pivot tables, you can follow this steps to add that function, then it will display the error as the values get change in the cell, or if the cell is empty. First of all click on the pivot table report, you?ll find there so many tabs, so among them select the option tab, in that option group click the arrow next to option and then click option, then click on the layout and format tab, in that you can add this formula.
Reply With Quote
  #5  
Old 17-05-2011
Member
 
Join Date: Nov 2008
Posts: 1,192
Re: Can we Edit Formula in Calculated Field in Pivot Table ?

It is also the function already provided in the excel worksheet itself, so you can easily add to the calculated field, but if you have to do the complex calculation frequently, so it provides the additional feature that let you make your own function too, you can then use the function to create formulas, so you won?t have to bother about the existing formulas. not even need to memorize those formula, instead here you can use the formula made by you only.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Can we Edit Formula in Calculated Field in Pivot Table ?"
Thread Thread Starter Forum Replies Last Post
How to copy a pivot table into a 2 dimensional table ? Udyami Windows Software 4 27-11-2010 11:35 PM
To convert a pivot table to a flattened table in MS Excel zeemga Windows Software 3 27-11-2010 06:48 AM
How to Create, edit or delete an array formula or Pivot Chart agarwalm11 Guides & Tutorials 1 31-12-2009 12:22 PM
Sharepoint list calculated field unique ID number NetWorm Software Development 3 10-06-2009 08:02 PM
How to edit formula field in Outlook ? Dwij Windows Software 3 14-04-2009 10:33 AM


All times are GMT +5.5. The time now is 07:10 PM.