how to add additional date and other column PIVOT table?

majid

New member
Joined
Oct 22, 2018
Messages
6
Reaction score
0
Points
0
Location
pakistan
Excel Version(s)
2013
Hi all,
i need your help to understand this how the attached file add to extra column in a pivot table. i received from some one but don't know to make this pivot?
i want to know about to add end of month and min and max column in pivot. please see the snap and file.
i am making a pivot but not to able to add month count. for example if item frequency is 2 on different dates but same month, count 2 whole month. my data is on specific date wise.
 

Attachments

  • Screenshot_2.png
    Screenshot_2.png
    20.3 KB · Views: 9
  • sample-countitem-datewise.xlsx
    134.3 KB · Views: 10
Back
Top