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.
<tbody>
</tbody>
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>