I am trying to modify a report built on a Cube Data Source. The report calculates standard metrics, (Qty, $ales, etc). I need to modify the report to calculate a "rate" (Qty/Day, $ales/Day, etc). Since the SSRS 2008 region can address only 1 Dataset, I modified my MDX query to retrieve both the metrics and the count of Days. (Qty and $ales are passed to the query via a parameter). So my dataset for Qty now looks like this where CYTD=CurrentYearToDate, PY=PriorYear: CYTD_Act CYTD_Bdgt PY_Act PY_Bdgt Store1Qty 100 150 1050 1000 Store2Qty 150 200 1500 2000 Store3Qty 125 125 2200 2000 Store1Days 88 90 300 330 Store2Days 45 75 330 360 Store3Days 90 90 360 360 The "rate" metrics I am try to calculate will allow me to compare store performance and account for the varying number of days that the store was open. My report aggregates day and brings back the appropriate calculations comparing the various measures. I can filter the dataset to bring back either "StoreXQty" or "StoreXDays". My question is: How do create an expression in SSRS to calculate this "rate" based on my combined Dataset? StoreXQty/StoreXDays. I had one idea of grouping the data by "Store" Then I retrurn two data points in my report. Is it possible to calculate a ratio based on the members of a group? Appreciate any suggestions.

Hi Gizmeaux, Thank you for the post. I have reviewed the requirement that you stated thoroughly. To my understanding, Store1Qty and Store1Days are different groups in SSRS, and you would like to carry out the "rate" by calculate Store1Qty/Store1Days, right? Correct me if I was wrong. If that is the case, I am afraid that it could not be done on SSRS directly. Instead, please insert the "rate" data into your MDX query, so that we can use it further. For more help, please look at SSAS forum below, SQL Server Analysis Services: http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/threads If you have any other question regarding SSRS, please feel free to ask. Thanks, Eileen

Hello Eileen. Thank so much for your reply. You are absolutely correct in understanding my issue. Just yesterday I succeeded at incorporating the "rate" information into my MDX query. My report is (almost) working as desired. Thanks again for your reply. Mario