Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Custom calculations in Dynamic Column Groups Expand / Collapse
Posted Thursday, June 17, 2010 9:17 PM


Group: General Forum Members
Last Login: Wednesday, December 30, 2015 2:11 PM
Points: 17, Visits: 368

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%)/3

Thanks once again.Appreciate your help!

  Post Attachments 
Report.jpeg.png (17 views, 55.33 KB)
Post #939330
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse