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

Add an additional field in Pivot Table Report

P

PineshM

New Member
Hello,

Attached Excel data base and pic of the report required.
Unable to find way to add or create the field "Part time.." in the pivot table.
Help will be appreciated.
Thanks
 

Attachments

  • Report Required.jpg
    Report Required.jpg
    89.6 KB · Views: 8
  • Course_9999_P.xlsx
    30.6 KB · Views: 4
Hmm, perhaps
  1. add the field Full_Time? to the Column area of your pivot
  2. replace SUM by COUNT in the value field setting
  3. rename the labels "0" and "-1" by Part Time and Full Time (just type in the cells)
62996
 
You must log in or register to reply here.
Back
Top