Hello , We are using SSRS 2008. I have a question.. which could be simple - but has totally stumped me here. Consider a simple table Country State Revenue Budget I have grouped it on country , then State so that report output looks like this USA NJ 200 100 PA 300 100 I now have a need to add column after Budget for Profit .. but that needs to be shown at country level. However any column i add - outside the group still splits the profit by state.. i am not able to escape the previous group level granularity. NJ 200 100 USA 30 PA 300 100 Is there any thing i can do here? May be an expression that calculates and displays data at group level of our choice? Thank you.

Hi Ramakes, From your information, I get your requirement completely. We might not be able to insert one group at the back of Budget to display the value like USA group. To work around the issue, here you could insert another column(Inside group-left) beside the group country , besides this, you could create another table to display the profit group by state, then join there two controls together utilizing another table. Of course, they are not a grace method just as workarounds. Thanks, Challen Fu