• 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 to change the date into month in pivot report?

S

sachar

Member
Dear All,

With reference to the attach sample file, with the help of pivot Tabletools I extract the report in column “Asset Received Date”. May I know, how can I get the same on a monthly basis instead of date wise.

Please help me?
 

Attachments

  • assets register_2016_Sample file.xlsx
    65.4 KB · Views: 3
One sample:
1) Select Cell [G4] from that sheet
2) Find 'Group'-button from 'PivotTable'
3) Select 'Group Field...'
4) Make wanted 'selection' and press [OK]
 
You must log in or register to reply here.
Back
Top