Monday, March 12, 2012

Formating drill down on SubTotal Column in Matrix

Hello Experts,

I have a Matrix in my report where on each each cell i have a drill down to another report. The Matrix also has SubTotal Column getting generated.

But the Problem is the drill down report gets carried on the SubTotal column also and the user gets vage results as proper information is not passed to another report.

Is there a way through which if its a subTotal cell then i can hide the drill down. some IIF() condition is there is

I appreciate if somebody can help me address this problem.

/Soni

The jump to report EXPRESSION should be something like:

=IIF(InScope("matrix1_YourGroupName"), "Other report name", Nothing)

No comments:

Post a Comment