How to create link for each dimension value in straight table

[ananyaghosh]

Hi,

In the attached image I have to create link for each dimension value in straight table. When I click on a link it will open a separate sheet with details for customer. Can it be possible here? as it is possible in Cognos.

Thanks,

Sandip

[Anonymous]

Instead of linking to another sheet you could do a conditional Show / Hide via the Layout tab of your table's properties with a condition like :

    GetSelectedCount(Firm)  <> 1

And this should hide the table when a single Firm is selected.

Then create your Customer Details object on the same tab with a conditional Show / Hide like :

    GetSelectedCount(Firm)  = 1

This should show those object when a single Firm is selected.

[HirisH_V7]

Hi,

Check this Example May be its helpful for u,

Using Field event triggers,

Else, we can do another way by placing transparent text objects on every dimensional fields .once clicking on them will direct to corresponding sheets.

HTH,

PFA,

Hirish