Showing multiple fields clearly in pivot table

[Tashamba]

Dear Expert Excel Users,

Can you tell me how I can show two sets of years (beginning year and end year) of assets clearly in separate columns. Here is my situation: I have assets that need to be replaced after decommissioning and we are looking at a period of 50 years. I have tried to put these in a pivot table but the years (beginning, and end columns)always end up in the same column entitled "Year" rather than fall under "Useful Life Start" and "Useful Life End" as I would like them to. How can I correct this?. Fields I want to see in the pivot table are: Relevance for 2016;Status;UseStatus;Begin & End UsefulLife. I realize I have to have values, so that will have to be the count of assets.

Asset ID	AssetName	Relevance for 2016	Status	UseStatus	BeginUsefulLife	EndUsefulLife
1	AA	Y	Confirmed	Live	1999	2006
2	BB	Y	Confirmed	Live	2001	2008
3	CC	N	Inactive	Decom	1989	2000
4	DD	TBD	Inactive	Live	2000	2012
5	FF	TBD	Inactive	Install	2015	2030
6	GG	Y	Confirmed	Test	2014	2025

<tbody>
</tbody>

 

[Mohammad Basem]

Hi Tashamba,

Are you looking for something like this?

Excel Workbook
	A	B	C	D	E	F
3	Count of AssetName
4	Relevance for 2016	Status	UseStatus	BeginUsefulLife	EndUsefulLife	Total
5	N	Inactive	Decom	1989	2000	1
6	TBD	Inactive	Install	2015	2030	1
7			Live	2000	2012	1
8	Y	Confirmed	Live	1999	2006	1
9				2001	2008	1
10			Test	2014	2025	1
Sheet

 

[Tashamba]

Hi Mohammad,

Thanks for responding. I re-tried this with the UsefulLives in the columns quadrant but what Excel did was bring in months (of installation and decommission) instead of years. The years just disappeared. Maybe a lesson in power pivot will help me.

Thanks again.

Tashamba

 

[Mohammad Basem]

Hi Tashamba,

The sample I posted is a pivot table, where all columns are in the Row Labels box and count of asset names in the Values box. Nothing in the Column Labels box.

I used the option Classic PivotTable layout.