COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: amic1 on 23 Aug 2011 02:10:18 PM

Title: rendering only top labels
Post by: amic1 on 23 Aug 2011 02:10:18 PM
hi,

I created a combination chart and trying render only top 5 (top 5 with the highest measure value)  labels in my category.
How can i restrict my chart only for top 5 labels in my category?

Thank You,

Amic
Title: Re: rendering only top labels
Post by: Arpitagrawal9 on 22 Sep 2011 06:43:13 AM
you can restrict that by doing that change in the report query create a data item calculating Rank of the measure and apply a filter stating rank should be greater than equal to 5