5 Replies Latest reply: Aug 12, 2017 1:12 PM by Pankaj Thakur RSS

    how to write calculate dimension

    naveen kumar

      Hi All,

             How to write a calculated dimension ,so that to display only those parts which has more then one price and whose date is greater than today for selected supplier

      from sample data as below

      part      supplier        price       date

      001        xxx             100       01-05-2017

      001        xxx             200       16-08-2017

      001        xxx             300       31-12-2020

      002        xxx             100       16-08-2017

      002        xxx             50        22-09-2017

      003        xxx             20        21-10-2017

      006        yyy            100        24-10-2017

      006        yyy             30         03-11-2017

      if i select supplier xxx then i need to display this in  normal table

       

      part       price

      001          200

      001          300

      002          100

      002           50

       

       

      003 part shouldn't come because it has only one price even the date condition is valid