Pivot table question

Question

Hello,
I need to create a pivot table that includes names and pivot each name based on their service dates for 1 year, 5 year, 10 year, etc. &nbsp;
How do I group all the names together within a specific year? &nbsp;
&nbsp;
Thanks.

richelle grajo · Answer

I was able to use your formula.. &nbsp; Thank you so much!!

haytham amairah · Answer

Hi Richelle,&nbsp;In the attached file, you will find a similar approach to what you are asking for.This is done by using a Table, not a PivotTable.&nbsp;Hope that helpsHaytham

richelle grajo · Answer

Yes, this is what I need to do.&nbsp; How do I create an employee table?&nbsp; Do you mind creating steps to accomplish this?
&nbsp;
Thanks.

haytham amairah · Answer

Richelle,&nbsp;You're welcome!In fact, that table is a dummy table I created in less than one minute!&nbsp;In your real table, you have to include the joining date for each employee, and then use the below formula to get the service years based on the joining date:=DATEDIF(B2, TODAY(), "y")&nbsp;After that, you can filter all employees with specific years of service by using a Slicer.&nbsp;Regards

richelle grajo · Answer

Hi,
Instead of calculating the years for today, how do I calculate the years for June 2018?
&nbsp;
Thank you,
&nbsp;
&nbsp;
&nbsp;

Forum Discussion

Pivot table question

7 Replies

Resources