If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Group a list

Started by jan54, 01 Aug 2012 06:40:28 AM

Previous topic - Next topic

jan54

Hi all,

Is it possible to group a list on different columns depending on a parameter.
So if I choose A it will group on column A, B on column B etc

Thanks
Jan

Lynn

Yes, it is possible. Create a data item in your query that resolves to either column A or B depending on the prompt selection. Then set the grouping to this derived column.

For example, the expression for the grouped column might be:


case ?groupParam?
when 'A' then [Namespace].[QuerySubject].[ColumnA]
else [Namespace].[QuerySubject].[ColumnB]
end


Good luck!