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

Pivot Table

P

phani

New Member
Emp ID 11-Jan-12 12-Jan-12

Total Special Tasks Total Special Tasks

499003 166.1 8 155.7 9

210009 170.2 9 178.1 7


I want to get data in the above format using the PIVOT?


Currently I have a huge data in the below format. Nearly 50 EmpIDs for 30 days (dates)

Emp ID Date Total specialtasks

499003 11-Jan-12 166.1 8

499003 12-Jan-12 155.7 9

210009 11-Jan-12 170.2 9

210009 12-Jan-12 178.1 7


please help
 
Phani


Firstly, Welcome to the Chandoo.org Forums


Select the data area including headings

Setup a Pivot Table

Drag the Emp ID to the Rows Labels

Drag the Date to the Columns Labels

Drag the Totals to the Sum Value Area

Make sure that the Special Tasks field is on Sum not Count


If you want to also see the Special Tasks as a sub set of the Emp Id drag the Special Tasks to the inside of the Row Labels


You may want to have a read of: http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/
 
Hi,

Thanks for the reply.


I want both the Total and special tasks data in the Value Area under the Date Column?


Regards,

Phani
 
You must log in or register to reply here.
Back
Top