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

running-count for a list table with section

Started by reginoilano, 26 Jan 2010 03:36:03 AM

Previous topic - Next topic

reginoilano

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

MFGF

#1
Hi,

Didn't we cover this a few days ago in this thread?  Is something different here (other than top 5 instead of top 10)?

MF.
Meep!

reginoilano