4 Replies Latest reply: Mar 6, 2012 5:47 AM by Damien Garzilli RSS

    Column() function

      Hi everybody,


      I was wondering if using the Column() function in a pivot table would optimized my application.


      Basically, let's say that I have 1 dimension : time, and 2 expressions : Sum(turnover), Sum(orders).

      In order to measure the average turnover per order in a third column, is it better to do :

      • this expression : SUM(turnover) / SUM(orders) ?
      • or, this expression : Column(1) / Column(2) ?


      Maybe, this is exactly the same...


      Thanks in advance for your answers.