I have a table of financial by division in a typical format:
Category/Division/2008/2009/2010
Revenue/Division A/xxxx/xxxy/xxxxz
Revenue/Division B/yyyx/yyyy/yyyz
Revenue/Division C/zzzx/zzzy/zzzz
Profit/Division A/xxxx/xxxy/xxxxz
Profit/Division B/yyyx/yyyy/yyyz
Profit/Division C/zzzx/zzzy/zzzz
I took the typical income statement format and added a column with the category
What I want to do is create a pivot pie chart where I can select the year and the category (i.e., 2009 revenue) and get the appropriate pie chart. Is there a way to filter by the year without rearranging the data?
Category/Division/2008/2009/2010
Revenue/Division A/xxxx/xxxy/xxxxz
Revenue/Division B/yyyx/yyyy/yyyz
Revenue/Division C/zzzx/zzzy/zzzz
Profit/Division A/xxxx/xxxy/xxxxz
Profit/Division B/yyyx/yyyy/yyyz
Profit/Division C/zzzx/zzzy/zzzz
I took the typical income statement format and added a column with the category
What I want to do is create a pivot pie chart where I can select the year and the category (i.e., 2009 revenue) and get the appropriate pie chart. Is there a way to filter by the year without rearranging the data?