Print Page - running-count for a list table with section

Title: running-count for a list table with section
Post by: reginoilano on 26 Jan 2010 03:36:03 AM

Hi,

I would like to get the top 5 products per store, this will have one query, what happen is that the list table has a section of store which will be splitted to certain number of tables based on the multi select store prompt.

how can I achieved to get the top 5 products per store in one query?

example:

section:Store 1

1 A
2 B
3 C
4 D
5 E

section:Store 2

1 F
2 G
3 H
4 I
5 J

Title: Re: running-count for a list table with section
Post by: MFGF on 26 Jan 2010 03:58:34 AM

Hi,

Didn't we cover this a few days ago in this (http://www.cognoise.com/community/index.php/topic,8713.0.html) thread? Is something different here (other than top 5 instead of top 10)?

MF.

Title: Re: running-count for a list table with section
Post by: reginoilano on 26 Jan 2010 05:51:01 AM

I apologize for the repost.. ;)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: reginoilano on 26 Jan 2010 03:36:03 AM