Conditional drill-through in the discontinuous crosstab report

[Ravisha]

Hello Cognoise,

I have a crosstab report (relational package) in which the measures are stacked in the rows (crosstab) and year in the columns. As shown in the attached image, the requirement demands to enable drill-through links on a specific intersection or tuple (cell value). For example, I have to enable the drill-through link for the tuple of 'Revenue' and year '2010'. Whatever is the value (no threshold for any measures) in the intersection belonging the aforementioned tuple must be drill-through enabled.

I tried using the conditional block and string variable approach on the year value '2010'. But, it enables the drill-through on the whole column '2010' rather than enabling for specific cells. Kindly please advise.

FYI, I've used 'Sales (Query)' sample package for the attached sample output.

Thanks in advance.

[sdf]

hi Ravisha,

I have an idea, but i haven't tried it though.
Is the year column a set or individual data items?
You can duplicate for example have two (2010) columns, then put drill through def on one. Work your way to hide the other cells. The idea is to show only the intersection you wanted.

Just an idea you might want to play around.

cheers!

[Ravisha]

Hello Sdf,

I appreciate your response.

It's a relational report and the column 'year' is just one data item. This column has the values 2010, 2011, 2012 and 2013. As shown in the attached image, the report design (crosstab) consists of only 1 data item in the rows.

Thanks

[Ravisha]

Hello Sdf,

Since it's just one data item (year) in the columns, I couldn't duplicate for just one year. Even though we manage to duplicate it and apply conditional drill-through, the whole column would be enabled for it. But, we just need specific intersection cells to be enabled for drill-through.

I'd appreciate it if anyone could please post their opinions and guide me accordingly.

Thank you.