Retrieve a Random Sample of rows from a Report

Problem

Description:[ How to create filters and calculations that retrieve a random sample of rows from the report. Solution: In your Impromptu report, do the following: 1. To start, your report must have a column with numbers in it. This column will be referred to as NUMBERS. 2.Add a calculated column ( Name this column: RANDOM NUMBERS ) to the report with the following definition: Round - near ( Rand ( NUMBERS ) * X, 0 ). This column will create random number for each number in the NUMBERS column and round them to be whole numbers (due to the 0 at the end). The numbers will range from 1 - X, where X is the limit. 3.Add a calculated column ( Name this column: Rank of RANDOM NUMBERS ) with the following definition: rank ( RANDOM NUMBERS ) for report. This column will rank these random numbers from 1 - Y, where Y is the number of rows in the report. 4. Add a summary filter as follows: Rank of RANDOM NUMBERS <= Z. This will limit the report to be Z rows long. The Report will now return random rows of Data. Keywords:] random data, random sample, random rows