• 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 in office 2016

villival

Member
Hi Team,

am using windows 10 enterprise with office 2016 edition , i need to prepare pivot table

before i was using office 2010 , i used to get the pivot as i required , after switching to

office 2016, am unable to generate the same pivot which i used to do in office 2010

attached is snapshot of office 2010 report and another file office 2016
 

Attachments

  • workbook.xls
    workbook.xls
    26.5 KB · Views: 5
  • office 2010.PNG
    office 2010.PNG
    11.1 KB · Views: 23
Go to PivotTable options -> Display. Uncheck show expand/collapse buttons.
Right click on each field and remove subtotal.

Then right click on Hours column and Ungroup.
 
Back
Top