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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Asset ID[/TD]
[TD]AssetName[/TD]
[TD]Relevance for 2016[/TD]
[TD]Status[/TD]
[TD]UseStatus[/TD]
[TD]BeginUsefulLife[/TD]
[TD]EndUsefulLife[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]AA
[/TD]
[TD]Y[/TD]
[TD]Confirmed[/TD]
[TD]Live[/TD]
[TD]1999[/TD]
[TD]2006[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]BB[/TD]
[TD]Y[/TD]
[TD]Confirmed[/TD]
[TD]Live[/TD]
[TD]2001[/TD]
[TD]2008[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]CC[/TD]
[TD]N[/TD]
[TD]Inactive[/TD]
[TD]Decom[/TD]
[TD]1989[/TD]
[TD]2000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]DD[/TD]
[TD]TBD[/TD]
[TD]Inactive[/TD]
[TD]Live[/TD]
[TD]2000[/TD]
[TD]2012[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]FF[/TD]
[TD]TBD[/TD]
[TD]Inactive[/TD]
[TD]Install[/TD]
[TD]2015[/TD]
[TD]2030[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]GG[/TD]
[TD]Y[/TD]
[TD]Confirmed[/TD]
[TD]Test[/TD]
[TD]2014[/TD]
[TD]2025[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.