IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
92 Posts

Pinned topic Summery issue while filtering the cross tab by rank.

‏2012-12-05T18:23:45Z |
Hello All,

I have a cognos 10.1 and DB2 9.7.

I have a cross tab with Product names in the rows and various measures in the column.

I also have a rank in the column based on one of the measure.

I just want to have the top 15 products in my report . So I tried to filter saying rank <= 15 but it seems to give an stich query error. SO I used a running-count on the rank field and filtered, running-count <=15. It works perfectly now with just 15 products. but the summary seems to calculate for the entire set of products instead of just 15 products.

I have set define contents = yes and used a new data item to calculate the summary (total(counts for products)), it doesnt seem to work.

Can anybody throw some light on the issue ? I would really appreciate it.