Hi, I am creating a report for Actual expense vs budget report, and I have question regarding hiding column while user expands group in matrix. Here is the structure I have: GL_Name VendorName Actual Budgeted + 2344 $5600 $4000 When user expands GL_Name VendorName Actual Budgeted - 2344 Dell $5600 $4000 Apple $1000 $4000 Microsoft $500 $4000 Problem I am having with my report is that our budgeted data doesn't get break down by individual vendor, so currently total budgeted amount gets repeated when user drill down the GL Name. What I am trying to achieve is follow: GL_Name VendorName Actual Budgeted - 2344 Dell $5600 Apple $1000 Microsoft $500 I want budgeted amount to be only visible when matrix is collapsed. My question is... 1. Is there way only only make total budgeted visible when matrix is collapsed? 2. Is there any better way to generate report for this type of situation? Thank you!

Hi Black, Based on your scenario, if we hide the values of Budgeted filed when clicking the + toggle, there will be a gap left below the text box Budgeted. This behavior occurs because we can set the visibility of the report items other than the visibility of data. If you want hide some items in the Budgeted column when drilling down the GL_Name, you have to hide the whole column at the same time. In addition, we can add a group header for VendorName group and then drag the Budgeted filed to the last column of the group header row. The report looks like this: To design this report, I use the steps below:Drag a Matrix to the design surface. Right-click on the handle of the second column and insert two columns outside the column group to the left.Drag the VendorName field to the first column of the second row, and then drag Actual and Budgeted fields to the second column of the second row.Right-click on VendorName in the Row Groups pane, select Add Group, and click Parent Group. Select GL_Name field in the drop-down list and check Add group header.Right-click on VendorName in the Row Groups pane and open the Group Properties. Click the Visibility tab, click Hide and select GL_Name in the drop-down list of Display can be toggled by this report item: Drag the Budgeted field to the fourth column of the second row. For more information about adding a visibility toggle to an item, please refer to: How to: Add a Visibility Toggle to an Item If you have any questions, please dont hesitate to let me know. Regards, Mike Yin