I have a separate table needed for the prompt query to pull client numbers and this table has no joins in FM model. The main query has the client number filter. When I run the report and select all the clients from value prompt, the revenue value is not coming correctly , but when I hardcoded these client numbers of the prompt query in Main query, then the revenue value is matching with the database query. My query is that after selecting the prompt values from the separate table, the filtering is not happening correctly , but when hardcoded the measure values reflects correctly.Any idea??
How exactly are you building the filter? What's the full definition? Are you using a wizard or pulling the field in directly into the filter editor?