SQL Server Performance Forum – Threads Archive
Working with Chart Data
Is there any way to define the grouping of data in a series? Ex. (I have a table with data like this) Year – Month – Value2000 – Jan – 5
2000 – Feb – 4
2000 – Mar – 1
2000 – Apr – 7
2001 – Jan – 6
2001 – Feb – 3
2001 – Mar – 1
2001 – Apr – 2
2002 – Jan – 2
2002 – Feb – 1
2002 – Mar – 5
2002 – Apr – 6 …and I would like the chart series to be as follows: ———- Feb – Mar – Apr – Jan
2000-2001 4 – 1 – 7 – 6
2001-2002 3 – 1 – 2 – 2
2002-2003 1 – 5 – 6 – <null>
Thanks!
Nevermind… was much easier than it should’ve been. FYI – for anyone else who needs it –> Using a matrix, you just need the following expression in the row or column you’re grouping data on: =iif(Fields!Year.Value<=2002, "2001-2002", iif(Fields!Year.Value<=2003, "2002-2003", iif(Fields!Year.Value<=2004, "2003-2004", "2004-2005")))
]]>