1 Reply Latest reply on Nov 23, 2016 4:30 AM by vinay gujjar

    Top 5 products showing as filter

    vinay gujjar

      hi i had a task to create a dimensional parameter showing with 2 dimensions (Region and segment) and one calculation with Top 5 products based on sales

      selected region in “Select Dimension parameter”. Below to that parameter, user can able to see the Region dimension values

      Similarly for the Segment dimension also.

      the out put will be like this

       

      here im able to achieve for region and segment by creating a calculated field

      if [Dimension Parameter]="Region"

      then

      [Region]

      ELSEIF [Dimension Parameter]="Segment"

      then

      [Segment]

      ELSEIF [Dimension Parameter]="Top 5 Products by Sales"

      then

      null

      END

      here im not understanding how to show the Top 5 Products by sales, i tried to create the Set by taking TOP 5 condition and i think its not the correct the idea its not working for as set is showing as a boolean value

      can any one help me to create the Top 5 Products by sales as filter

      the requirement is as below

        • 1. Re: Top 5 products showing as filter
          vinay gujjar

          I have achieved the task by just creating the set by top Products by sales and just dropped the Set in the Filter self its working and in calculated field i just created,

           

          [Region]

          ELSEIF [Dimension Parameter]="Segment"

          then

          [Segment]

          ELSEIF [Dimension Parameter]="Top 5 Products by Sales"

          then

          [Product Name]

          END

           

           

          and set as