COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sidney786 on 26 Mar 2014 05:59:22 AM

Title: Detailed filter content in layout calc?
Post by: sidney786 on 26 Mar 2014 05:59:22 AM
Hi

Does anyone know how to display the detailed filer condition in the layout calc.

Not a prompt variable as i know how to do this.

i.e. sales region = 'Asia'

I want to display Asia

Thanks in advance

Sid
Title: Re: Detailed filter content in layout calc?
Post by: navissar on 26 Mar 2014 03:30:00 PM
For a single value it's easy. Add in a singleton based on the same query with the data item (minimum([Region]) which will return the one value from region that you filtered by.
For multiple values, you could use a repeater or a list to get the data item with all the regions in the query.