Drillthrough from table/pivot

[imtiaz_ullah]

Hi guys,

Does anyone know a way of drilling through (not dimension drill down) to the raw data behind a pivot table at a cell level?

I've seen ways to drill-through to another document from a different object, but not from within a table.

Thanks

Immy

[Gysbert_Wassenaar]

Perhaps like in the attached example.

[imtiaz_ullah]

Is this done just by displaying an additional table when =len(GetCurrentSelections()) ?

[Gysbert_Wassenaar]

Yes.

[imtiaz_ullah]

Thanks. What other settings do I need as it doesn't seem to work with just that condition. Is there something else I need to set as the box is always displayed.

[imtiaz_ullah]

OK, I've figured it out, but actually this doesn't seem to be the solution I am looking for.

The hidden table always shows when I click on any row, but that's not actually what I am looking to do.

I want to be able to have a Pivot table and then expand down to the most granular level. When I am there, I would like the raw hidden data to be displayed when I click on that  row.

Thanks