Help

Thu, 17 May 2012 04:47:15 GMT

I want to filter out top five and bottom five sales ,

on a chart ,i want to impliment it with suing button,

pls provide suggestion how to create button which filter to five as well as below five.

Re: Help

Sokkorn — Thu, 17 May 2012 06:50:41 GMT

Hi,

Let try

Step1: Load data

[Data]:

LOAD * INLINE [

No,Product,Sale

1,P1,10

2,P2,15

3,P3,5

5,P4,25

6,P6,12

7,P7,9

8,P8,7

9,P9,17

10,P10,11]

Step2: Create variable by Goto Settings ==> Variable Overview ==> Add ==> Give variable name <vShow>

Step3: Create Button <Top 5> with action <Set Variable>

. Variable : vShow

. Value : SUM(IF(AGGR(RANK(Sale),Product)<=5,Sale))

Step4: Create Button <Bottom 5> with action <Set Variable>

. Variable : vShow

. Value : SUM(IF(AGGR(RANK(Sale),Product)>=5,Sale))

Step5: Create a chart with

. Dimension : Product

. Expression : =$(vShow)

See the sample attached file.

Regards,

Sokkorn