Thursday, August 25, 2016

Calculated Fields on Pivot Tables [Solved]

Calculated Fields on Pivot Tables


I'm new with Excel pivot table.
I use it to grab fields data from a SQL database.

Is there a way to do calculated values on the fields after it is dropped into the table?

For example I have field A and field B.Field A is string and Field B is float.

Field A can be:

25% - Almost not qualified
50%  - Halfway qualified
or 100% - Qualified.

Field B is any number.
I want to create a new field C that calculates Field A * Field B.
It would be better if it can do IF statement also, for example:
If (A= "25% - Almost not qualified", .25*B, If (B = "50%  - Halfway qualified", .5*B, B))

Is this possible to do in Pivot table? I tried to write the formula on the column but it doesn't allow me to click on it.

Thanks in advanced for your help, greatly appreciate it!

-Elizabeth K.

Solutions to the Problem Calculated Fields on Pivot Tables

Download SmartPCFixer to Fix It (Free)

  • Go to the Start button.
  • In the Search box, type "cmd" (without quotes) and press Enter.
  • At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
  • Restart your computer.

Recommended Method to Fix the Problem: Calculated Fields on Pivot Tables:

How to Fix Calculated Fields on Pivot Tables with SmartPCFixer?

1. Download SmartPCFixer. Install it on your computer.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.

Related: How to Download Toshiba Portege R500 HDD/SSD Alert Utility v. driver,Way to Update & Download Toshiba Satellite A355-S69403 Motorola Modem Region Select Utility v. driver,Where to Download Toshiba Satellite L305-S5926 HW Setup Utility v.2.00.11 driver,[Solved] Download Toshiba Satellite L675-S7115 Laptop Checkup v. driver,Method to Download Toshiba Satellite M645-S4080 Media Controller v. driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: Troubleshooter of Error: Calculated Field does not give the correct result,[Anwsered] browser window size,Fast Solution to Error: Blurry screen, large desktop icons, Colour all funny something to do with NVIDIA GeForce 8300?,[Solved] Blutooth mouse has quit working. Changed batteries and still does not work. Cut it on and green battery light goes out. Press the button on the underside next to the power button and it flashes red and green.,[Anwsered] BSOD need help, I am posting DMP file,All diagnostic tools give 0x800700C1, troubleshooting wizard can't continue,all files try to open with adobe,all icons on desktop have changed to Adobe icon and won't open,All functions of my outlook are working except it will not let me "REPLY" or start a "NEW" email,all f1-f12 shortcuts not work

No comments:

Post a Comment