HI,, I have report which has two static prompt options like 1)upto 50% and 2)ALL based on this i have created a rowvisibility expression to hide records based on the Margin percentage.Records are filtering and everything is fine but I have Engagement as group and it has totals iam getting Engagement sub totals static ..i mean if i get 10 rows for upto50% options and their totals =30000 and even for ALL option i get same total. but records are more. Note:Records are filtering fine but based on record values iam not getting sub totals changed. I have tried expression using =sum(fields.value,"datasetname") or Running value ------but no luck thanks krish

For faster help can you post designer image? Just upload image to www.skydrive.com then copy and paste.Kalman Toth, Admin/Prog, SSAS, SSIS, SSRS; SQL 2008 GRAND SLAM

Hi Krish, Generally, if hide the some rows in the table, values of these row are still evaluated for aggregation. In order get the correct sum, we need to add a filter. For example, please add a filter in Tablix Properties based the value of the parameter Margin, and then in the Engagement group footer, we only need to specify the expression =sum(Fields.fieldname.Value). For more information about How to Add a Filter, please refer to: http://msdn.microsoft.com/en-us/library/ms156270.aspx Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.