Percentage by Column by Dimension

[sonysree88]

Hi All,

I have 1 filed that have number ofrecords for example.1000 recs

I need 26th of percentage of all the records.

how to get this.Please provide solution asap.

Regards,

Sunitha

[MohammedMustaq]

Hello,
In general 1000*26/100=260 Records

Try
But if you need to write in Expression!
=Count(recs)*26/100.

=Count([Field Name])*26/100

Thanks
Mustaq

[LVillage]

Hi,sonysree88

How about the following method?

1.Assign row numbers in the load script.

====<example:load script>=====

LOAD
     rowno() as row,
     Field1
FROM
…
;

2.Create a flag to determine the top 26%.(1:Top 26%  0:other)

====<example:Listbox Formula>=====

=if(row > round(max(total row)*0.26),0,1)

3.If you select "1" in the list box, you will be able to get 26% of records

Thanks.