Hi All,
I use dimensional model.
In the table has several columns which are indicators, they contain three types of values.
The table and the columns looks like this:
|Dispute Cycle Time IND | |OTD xSeries in Time IND | |BA Project Based Services IND | |BA Annuity Services IND |
| |A | |G | |A | |R |
| |G | |A | |G | |G |
| |R | |A | |A | |A |
Should make a prompt, which displays (('А', 'R' или 'G') i.e. the contents of columns) the selected symbol to refer to all columns in this way makes filtration.
In another way stated.
How to merge different columns in a prompt, which not to display the column names and their content.
In this photo is the result that should be filtered. Should show only ('A'.'R')
Thanks.
You could build an expression as part of your report query that concatenates the columns together. Use this same expression in a query for the prompt, then when filtering check if the query item is equal to the selected prompt value. If I understand your requirements correctly, that should do the trick.