Issue with displaying report data using interactive filter in dashboard

[mohanambalnanja]

Hi All,

I have created a Database view to get the data from two tables and created a report(pivot table). 

Added that report to the dashboard and in dashboard I used interactive filter to filter the data based on County.

When there is no country is selected the report is coming as expected. 

But if select the any specific country, the "Registered Users" false data is not coming.

Attached the screenshot.

Can someone help me fix the issue?

Thanks

[Brian Lancaster]

Since you are using a Database View did you set the "Interactive Filter References" on the interactive filter to use the correct table and field?

[mohanambalnanja]

Thanks for your response. After updating the correct field in interactive filter reference the issue fixed.