Hi All
I have a table with below field names
ID Type Jan Feb Mar Apr ..... Dec
001 YTD 12 15 13 20
001 Y-1 15 18 25 17
002 YTD 11 18 13 14
002 Y-1 15 65 11 17
003 YTD 17 18 33 11
003 Y-1 20 44 43 11
What i m looking to do is filter to ID so that i can get a graph representing YTD against each month for a year and Y-1 the same both on the same graph...
Looking for some guidance on how best to display this in graph format but finding it hard to figure out where i put the items in a pivot table...altenatively what other options available to display in graph format
Apprecaite anyones help
Ali
I have a table with below field names
ID Type Jan Feb Mar Apr ..... Dec
001 YTD 12 15 13 20
001 Y-1 15 18 25 17
002 YTD 11 18 13 14
002 Y-1 15 65 11 17
003 YTD 17 18 33 11
003 Y-1 20 44 43 11
What i m looking to do is filter to ID so that i can get a graph representing YTD against each month for a year and Y-1 the same both on the same graph...
Looking for some guidance on how best to display this in graph format but finding it hard to figure out where i put the items in a pivot table...altenatively what other options available to display in graph format
Apprecaite anyones help
Ali
