InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 04:52:35 GMT20http://www.sqlservercentral.com/Forums/Topic939330-1633-1.aspxHI ALL,I am stuck in a project on custom calculations and need your suggestions. Below is the scenario. I have also attached printscreen of the design and as well as the report.Thanks in advance.I have a column group based on Sales(sales40%,sales60%,sales 80%) and with Price as detail.I wan to do a custom calculations in (Adjusted Sales) and suppose the calculation is (opp 40%+opp60%/opp80%)/3. How do i perform this? In the design pane it is just one column called "Sales" which on runtime gives me 3 columns(Sales40%,Sales 60%, Opp 80%).Sales40% Sales 60% Opp 80% Total Total rows (Adjusted Sales) $500 $1000 $1039 $2539 109 (opp 40%+opp60%/opp80%)/3Thanks once again.Appreciate your help!:-)Thu, 17 Jun 2010 21:17:03 GMTsammm