COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: destry2 on 27 Mar 2013 10:13:52 AM

Title: Adding an aggregated report of prompted values
Post by: destry2 on 27 Mar 2013 10:13:52 AM
Hi, is it possible to add an aggregate or summary of the values selected in a tree prompt. For instance, a user runs a report and selects regions A, C and D. Regions are paginated, so the user will see a report page per region based on their selection. How would you add an aggregate page of the regions selected in the prompt? Thanks
Title: Re: Adding an aggregated report of prompted values
Post by: absriram on 27 Mar 2013 11:08:39 PM
Just add a new page after your current page and create a list with aggregate report here.

Sriram.
http://www.cognosonsteroids.com (http://www.cognosonsteroids.com)
Title: Re: Adding an aggregated report of prompted values
Post by: destry2 on 28 Mar 2013 02:54:15 PM
Hi Sriram,

Thanks for the response. I was hoping there may be a function that I could use that would add a summary of the selected values from the prompt. If not, could you give me a little bit more detail of the steps involved in your solution.
Thanks