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.

       

      Damien