S
shaun.tyndall
Hi there,
I currently use a Pivot table to display actual finance data via
numerous filters, for example say "actual income" (column) filtered by
"theme", "category" and "date" (rows).
The dates are in the form "2006-07" etc, and reside in a row in my
pivot table.
I would like my column data (actual income) to be split by years so i
can show a comparison across previous years. At the moment, I can only
show it in a messy way, and not in columns.
example below - Id like to show for "East" the yearly comparison in
columns, with a column for each year.
Can this be done? Any help would be hugely appreciated!
Community <All MST Wards> 2007-2008 7725.42
<Central> 2006-2007 75918.52
2007-2008 0
<East> 2005-2006 195602.93
2006-2007 161019.82
2007-2008 15
<Manchester> 2006-2007 59781.12
I currently use a Pivot table to display actual finance data via
numerous filters, for example say "actual income" (column) filtered by
"theme", "category" and "date" (rows).
The dates are in the form "2006-07" etc, and reside in a row in my
pivot table.
I would like my column data (actual income) to be split by years so i
can show a comparison across previous years. At the moment, I can only
show it in a messy way, and not in columns.
example below - Id like to show for "East" the yearly comparison in
columns, with a column for each year.
Can this be done? Any help would be hugely appreciated!
Community <All MST Wards> 2007-2008 7725.42
<Central> 2006-2007 75918.52
2007-2008 0
<East> 2005-2006 195602.93
2006-2007 161019.82
2007-2008 15
<Manchester> 2006-2007 59781.12