1 Reply Latest reply: May 17, 2012 2:50 AM by Sokkorn Cheav RSS

    Help

    Shantnu Patel

      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 Cheav

          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