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

Report Studio : Splitting Rows in 2 lists side by side

Started by kaivalya, 29 Jan 2007 07:01:15 AM

Previous topic - Next topic

kaivalya

Hi all,
My query has say,
[Product type] (grouped), [Order method], [Revenue] objects. The list generates 147 rows.
the requirement is the output should be in 2 lists side by side on a page.
I created 2 lists, both queries populated with same objects from source.
created 1 calculation object for each query with qurtile([revenue], 147 for [product type]) . & applied filter on it as [counter]<=75 for query1(List1) as well asÃ, Ã,  [counter] >75 and [cunter]<=147 for Query 2 (List2)
does'nt work.

i tried using count([Revenue] for report) for [Counter]
but the count([Revenue] for report) gives only 1 value i.e. 147 spanning throughout all the rows. so the filter
Counter<75 on Query1
& Counter1>=75 and Counter1 <=147 on Query 2 doesn't work.
any workarounds please?


if i have [product type] & [revenue] & use rank() as counter & filter [product type] by counter it works fine.

Can anybody please help me in sorting this issue?

Thanks in advance.
Regards,
Kaivalya.

Octavio

Try using these filters:

running-count([Revenue]) <= 75 on one list and running-count([Revenue]) > 75 on the second list.

kaivalya

Hey Octavio,
Thanks a lot!

i was playing around in more harder way, unneccesserily.

Thank you.