Create Calculated Table

[Anonymous]

Hi,

  I have a requirement of having drllthrough page with detail records shown from different table according to filter they select. That drillthrough page will have a table visual which can be bind to calculated table which should take source from either of 4 master tables according to filter selected. Can we create a dynamic table which populates values either from different table according to report filter?

Thanks
Vivek

[TeigeGao]

Hi @Anonymous ,

The calculated table will be calculated when data imported, it will not be affected by the filter.

In your scenario, we can create some measure to control the rows display. For example, we can create a measure which will return 0 or 1 and create a report level filter to filter the measure >=1.

Best Regards,

Teige