• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do i edit a inserted Blank Column in Pivot Table

S

santhurcv

Member
How do i edit a inserted Blank Column in Pivot Table .


Example :

P1 Tickets

Month Out of SLA WithinSLA OLA Per %(Blank Which is inserted) P1 Total

Jan 3 7 10

Feb 5 10 15

Mar 6 6 12

Apr 10 12


i want my simple formula as =WithinSLA/P1 Total in OLA Per % Column.


is there a way to calculate it in Pivot Tabel. it self


i have uploaded the sample file

https://dl.dropbox.com/u/94380636/New%20Microsoft%20Excel%20Worksheet.xlsx


Thanks in Advance
 
Santhurcv


You want to add a Calculated Field

Refer: http://chandoo.org/wp/2010/02/25/p-l-reports-calculated-fields-3/
 
Hi Hui,


Yes i want to calculate Field as said in my Previous Question i have even uploaded the sample file for the same.


Actual file will be updated with the fresh data every month.


i want it be shown as Formula or VBA which will help me to say how that was calculated.


you can try with Calculate field on the sample file that i have uploaded.


Thanks
 
santhurcv In the worksheet with your pivot table click on table then in the ribbon, choose PivotTableTools then Options, then in the calculations section choose Fields, Items and Set then click on Calculation Field,

The link posted by Hui gives very clear working instructions on inserting a calculated field.
 
You must log in or register to reply here.
Back
Top