4 Replies Latest reply: Feb 13, 2015 3:29 AM by Gysbert Wassenaar RSS

    top 3 Values in text box

    saurabh singh

      hi All,

      i want a text box with top 3 values from my data based on the the expression:

       

      Category  ID
      Plan A      1

      Plan A      2

      Plan A      3

      Plan A      4

      Plan B      5

      Plan B      6

      Plan C      7

      Plan D     8

      Plan D      9

      Plan D      10

      Plan E      11

       

      so basd on the expression count(distinct ID)

       

      i want a text box stating:

      Top 3 plan for this month are:Plan A,Plan D and Plan B.