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!:-)