21 Replies Latest reply: Jan 5, 2016 4:12 AM by ahmar ansari RSS

    Adhoc Report with Column() ?

    ahmar ansari

      I have dynamic measure and dimension created for Adhoc report using inline

       

      Dimension
      Plant
      Product Group
      Product Type
      Product

       

      Measures

       

      QYT
      Value
      Freight
      Other Value
      Total Value

       

      Here Total Value=Value+Freight+Other Value

      so

      1-I am using column() function in Expression for Total Value like

           Column(2)+Column(3)+Column(4)

           but when I select only Total Value then it show Total value output as  null

      2-if I used  Total Value=Value+Freight+Other Value it takes more time to load

       

      kindly suggest any solution for the above problem.

       

      Thanks & Regards

      Ahmar