Hi,

I was able to implement this with pivot and matrix report. I have all the row groups in the beginning and column groups in the end in the report. But I need couple of row groups to be at the end of the report. I changed that order in the data set but it's not showing up in the report. Is there a way I can drag them to the end.

I have report headers like the following.

country,State,city,total,avg,jan2012,feb2012,mar2012,apr2012,may2012...dec2012.

in the above headers jan2012 to dec2012 comes from column group and the others from row group.

Now I want the display to be like the following

country,State,city,jan2012,feb2012,mar2012,apr2012,may2012...dec2012,avg,total

How can I do this?

Thanks.