Cognos Prompt page paramater values

[Dan Smith]

I am using Cognos 10.2 Report Studio.

I have determined the Top 5 Products by Reveue % in my queries for the year 2017 & 2018. The user wants to Industry level % to be input by the user on the prompt page for  Product.

So that chart displays Top 5  Products as a bar chart. The bar chart will have 3 bars - one for 2017, second for 2018, and the third one as the Industry Level % entered on the prompt page.

How do I pass that parameter value typed on the prompt page(text box prompt) to tie in with that respective product?

One solution I though is I can have a Pass Through SQL with #sq prompt code to fetch the prompt parameter values. But how do I dynamically determine that 5 values entered on the prompt page be tied to the Top5 Products in the query?

[dougp]

Just add a data item that uses the parameter.