cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vivekrs Regular Visitor
Regular Visitor

Create Calculated Table

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

1 REPLY 1
TeigeGao New Contributor
New Contributor

Re: Create Calculated Table

Hi @vivekrs ,

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