COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Business Insight Advanced / Cognos Workspace Advanced => Topic started by: trumaneileen on 30 Jul 2013 11:48:52 AM

Title: BIA CAN YOU FILTER ON A QUERY CALCULATION
Post by: trumaneileen on 30 Jul 2013 11:48:52 AM
I am trying to filter on a couple of columns I created through Query Calculation.  I can't filter on these columns. Does anyone know if this is possible?  If yes, please explain.
Title: Re: BIA CAN YOU FILTER ON A QUERY CALCULATION
Post by: Lynn on 30 Jul 2013 12:23:43 PM
I assume it is a relational source you are working with?

Did you try to click on the calculated column and then use the filter icon from the toolbar? This should bring up a variety of choices for filtering based on that item.
Title: Re: BIA CAN YOU FILTER ON A QUERY CALCULATION
Post by: trumaneileen on 06 Aug 2013 09:49:19 AM
Thank you, that worked. New at BIA/WORKSPACE ADVANCED.   :D