4 Replies Latest reply: Jul 17, 2014 10:36 AM by 1759366 RSS

    Table prompt modification

    2682943

      Hi I have a requirement like

       

      I created a report and use date as Table prompt, now the value  of the date are showing in ascending order,

       

      like - 01-Jan-2014

              02-Jan-2014

              03-Jan-2014

       

      and 01-Jan-2014 date is showing as default value.

       

      But my requirement is like, i have a   column call Error, and i want to show the date as default which have highest number of error


      like           Date               Error

                     01-Jan-2014     40

                     02-Jan-2014     30

                     03-Jan-2014     50

       

      so the table prompt should look like as below:

                03-Jan-2014

                01-Jan-2014

                02-Jan-2014

       

      Thanks,