<p>My report specs is summed up by the illustration below:</p><p> </p><p><span style="font-size:10px;">[font="'courier new', courier, monospace;"]
+
+
+
+[/font]</span></p><p><span style="font-size:10px;">[font="'courier new', courier, monospace;"] | January | February | March |[/font]</span></p><p><span style="font-size:10px;">[font="'courier new', courier, monospace;"]
+
+
+
+[/font]</span></p><p><span style="font-size:10px;">[font="'courier new', courier, monospace;"] Dealer | Target | Actual | % | Target | Actual | % | Target | Actual | % | [/font]</span></p><p><span style="font-size:10px;">[font="'courier new', courier, monospace;"]
+
+[/font]</span></p><div><p><span style="font-size:10px;">[font="'courier new', courier, monospace;"] P501 | 100 | 90 | 90 | 100 | 85 | 85 | 100 | 93 | 93 | [/font]</span></p><p><span style="font-size:10px;">[font="'courier new', courier, monospace;"]
+
+[/font]</span></p><div><p><span style="font-size:10px;">[font="'courier new', courier, monospace;"] P502 | 100 | 90 | 90 | 100 | 85 | 85 | 100 | 93 | 93 | [/font]</span></p><p><span style="font-size:10px;">[font="'courier new', courier, monospace;"]
+
+[/font]</span></p><div> </div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"]a) the number of months to be displayed is passed as a parameter. For quarterly report, there will be 3 months; for semi-annual there will be 6 months; for annual, all 12 months will be shown.[/font]</span></div><div> </div></div></div><p><span style="font-size:12px;">[font="'courier new', courier, monospace;"]
the Region, Target and Actual data are read from a database table using the SQL statement below:[/font]</span></p><p> </p><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] select concat(d.dealer_code,"-",dealer_name) as dealer[/font]</span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] ,s.month[/font]</span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] ,case [/font]</span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] when s.month="1" then "January" [/font]</span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] <span> [/font] when s.month="2" then "February" </span></span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] <span> [/font] when s.month="3" then "March"</span></span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] <span> [/font] when s.month="4" then "April"</span></span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] <span> [/font] when s.month="5" then "May" </span></span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] <span> [/font] when s.month="6" then "June"</span></span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] <span> [/font] when s.month="7" then "July"</span></span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] <span> [/font] when s.month="8" then "August" </span></span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] <span> [/font] when s.month="9" then "September"</span></span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] <span> [/font] when s.month="10" then "October"</span></span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] <span> [/font] when s.month="11" then "November" </span></span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] else "December" [/font]</span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] end as month_name[/font]</span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] ,case[/font]</span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] <span> [/font] when s.type = "PA" then "Actual"</span></span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] <span> [/font] else "Target"</span></span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] end as type[/font]</span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] ,s.amount[/font]</span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] from t_pbo_sales s, t_pbo_dealer d [/font]</span></div><div><span style="font-size:12px;">[font="'courier new', courier, monospace;"] where s.dealer_id = d.id[/font]</span></div><div> </div><div>c) the % performance column is a computed field which is simply calculated as: actual / target * 100</div><div> </div><div>d) The cube has the following structure:</div><div> Groups (Dimensions)</div><div> DealerGrp - dealer</div><div> MonthGrp - month_name, type</div><div> Summary Fields (Measures)</div><div> Summary field - amount</div><div> </div><div>I added a Derived Measure to hold the value of the % performance column. It is appearing correctly besides the Target and Actual columns for each month but I can't figure out how to provide its value (see formula from item c above)</div><div>. </div><div>What is the best way to accomplish this?</div><div> </div><div>Any help would be greatly appreciated. </div>
