This function determines the rank of a value in terms of a
user-specified range
Syntax: NTILE(expr,
numTiles)
Syntax description
expr is any expression that evaluates to a numerical value.
numTiles is a positive, nonnull integer that represents the number of
tiles.
Steps: Go to Criterial – Select the Column – Right Click –
Select Edit Formula – Click on Insert function – click on Aggregate folder and
select NTile
Example: NTile("Sales"."Rp
Revenue",12)
No comments:
Post a Comment