Dear all,

Background:
I have a Table as below:

Name:  Table.jpg
Views: 261
Size:  22.2 KB

Basically, this table shows the status of the employees of a company from Dec-15 to Mar-16.

Pivot Table Result:
Then I try to use pivot table to illustrate the employment status of each month to my boss. However. the result is as below:

Name:  PivotTable_Result.jpg
Views: 259
Size:  36.0 KB

Expected Result:
Actually, I want to use pivot table to provide me a summary table as below:
Name:  Expected_result.jpg
Views: 220
Size:  66.8 KB

My question:
My question is, how to use "pivot table" to produce the above expected result table? My boss insist to use pivot table because he think that pivot table can provide him a better data grouping view (has the expand button) and he can use the slicer as filtering.

Hope my question is clear enough for your understanding. Thank you very much in advance.