I've set up a summary report that allows users to drill through to a more detailed report. The source report (summary) is set up as a matrix with several column groups. When a user clicks on a cell, I'm able to drill through using the column values as parameters for the detail report. But if column groups are collapsed - I'd only like to send parameters for column groups that are open. Example: I have 2 column groups (CG1, CG2). When expanded the matrix looks like this: -CG1-Val1 -CG1-Val2 CG2-Val3 CG2-Val4 CG2-Val3 CG2-Val4 Row 1 cellA11 cellA12 cellA13 cellA14 Row 2 cellA21 cellA22 cellA23 cellA24 When a user clicks on cell A21: Param Row: 2, Param CG1: Val 1, and CG2: Val 3 are sent as desired BUT, When collapsed the matrix looks like this: +CG1-Val1 +CG1-Val2 Row 1 cellA11 cellA12 Row 2 cellA21 cellA22 if the user clicks on cell A21 I'd like the following parameters to be sent: Param Row: 2, Param CG1: - Val1. I do not want any parameter sent for CG2. I tried using the Omit function - but how does a cell know whether or not it is part of a collapsed group? Does InScope work for columns?

Hi DanDoney, You could utilize InScope and IIF function to know whether or not a cell is part of a collapsed group, just like this =iif(inscope("CG2GroupName"),value1, value2) here CG2GroupName is your second column group name. Thanks,Challen Fu [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.

Hi DanDoney, You could utilize InScope and IIF function to know whether or not a cell is part of a collapsed group, just like this =iif(inscope("CG2GroupName"),value1, value2) here CG2GroupName is your second column group name. Thanks,Challen Fu [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.

Thanks. The mistake I made was using the column name instead of the groupname in the InScope eqn.

Thanks. The mistake I made was using the column name instead of the groupname in the InScope eqn.