1. SET WISE - TOP 10 AND BOTTOM 10 - USING SINGLE WORKSHEET
FIRST CREATE 1 SET AS TOP n
SECONDARY 1 SET AS BOTTM N
DO COMBINED SET
DRAG AND DROP IN TO THE ROW.
2. PARAMETER WISE - TOP 10 AND BOTTOM 10 - USING SINGLE WORKSHEET
CREATE -2 PARAMETERS TOPN / BOTTM M
CALCULATION FILED -
IF FIRST PARAMETER NAME THEM 'TOP'
ELEIF LAST PARAMETER NAME THEM 'BOTM'
ELSE "OTHER"
END
THIS FILED DRAG AND DROP INTO THE COLORS
3.CONTEXT FILTER
TWO FILTERS ACT AS A INDEPENDENT
WHEN U APPLY THE CONTEXT ONE FILTER ACT AS A INDEPENDENT
ANOHER FILTER ACT AS DEPENDENT -OUTPUT
PERFORMACE LEVERL USED
4.DISCRET AND CONTINOUS
DISCRET MEANS- INDIVIDUAL SEPARETED DATA FILED- BLUED/DIMENSION
CONTINOUS - UNBROKEN VALUES- GREEN/MEASUERE VALUES