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.
Try using these filters:
running-count([Revenue]) <= 75 on one list and running-count([Revenue]) > 75 on the second list.
Hey Octavio,
Thanks a lot!
i was playing around in more harder way, unneccesserily.
Thank you.