Hello, Thank you in advance for your help.
I would like to make a table out of prompt values, that I can then left join to my search, or another way to preserve my prompt values.
If I prompt A B C D and have matching data for A B D I get
A - Data
B - Data
D - Data
I need a way to get
A - Data
B -Data
C -No Data
D -Data
Any suggestions?
Thank you
I had a similar problem.
Assuming your filter items are from a dimension try this;
Create a query which has just the dimension in it and add a filter from the prompt and no other report filters.
Then outer join this to the main query.
In the joined query just make sure you select the row data from the first query.
If your prompt items aren't from a dim then you'll need a different solution.