Hi, I'm using sql 2005 and a Matrix Tablix. I want to exclue a column group when the field (of the column group by) is "IAP3". I used the formula below but it's not working. =IIf(Fields!transactiontypecode.Value Like "IAP3", "", Fields!transactiontypecode.Value) Thank you.Lapucca

Hi, Generally, in order to exclude a column which value is “IAP3”, we can add a filter to the column group. Please refer to the steps below: 1. Right click the handle of the matrix and select Properties. 2. In the Matrix Properties window, select the Groups tab. 3. Select the column group name in the Columns list, and then click Edit… 4. In the Grouping and Sorting Properties window, select the Filter tab. 5. In the Filter grid, select = Fields!transactiontypecode.Value in the Expression column; select != in the Operator column; type in IAP3 in the Value column. After that, the column IAP3 would not be displayed in the matrix. In addition, you can also add the filter in the matrix level or dataset level based on your requirement. For more information about How to Add a Filter, please refer to the link below: http://msdn.microsoft.com/en-us/library/ms156270(v=SQL.90).aspx Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help

Thank you.Lapucca