Custom calculations in Dynamic Column Groups

• sammm

  SSC-Addicted

  Points: 425

  More actions

  June 17, 2010 at 9:17 pm

  #222389

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

  Thanks once again.Appreciate your help!:-)