Subtotalling Top/bottom N

system · August 31, 2009, 9:50pm

I created a sub report that returns Top 20 values. When I total it it gives me the overall total, not the total of the top 20. Is there a way to accomplish this?

It seems so easy but I’m stuck.

tcoyer (BOB member since 2009-08-31)

system · September 1, 2009, 9:00am

Hi,

You can create formulas to get the total of top 20 values.

Cheers!!!
Manish

cr_manish (BOB member since 2009-07-30)

system · September 1, 2009, 1:37pm

can you point me in the right direction?

I’m finding formulas for Nth largest, but not a top N formula.

tcoyer (BOB member since 2009-08-31)

system · September 1, 2009, 4:17pm

nm I eventually got it.

thanks.

tcoyer (BOB member since 2009-08-31)

system · September 8, 2009, 4:04pm

have you manage to find a way to have the subtotal?
i try a loop zwith the nthlargest function but the function does not accept a variable…

g_nat (BOB member since 2009-09-08)