7 Replies Latest reply: Feb 21, 2013 11:00 AM by Aio Aio RSS

    Pivot table: incremental count expression of the first N elements

    Aio Aio

      Hi everybody,

       

      I'm working with pivot table, I've got a column with the factory (the most productive ones),in the second the count of produtcs built in the factory,  in the third the incremental counter (but only for the first 35 or 10 elements), in the 4th the percentage of the incremental counter (on the total) .

       

      factorynumber productincremental count% on the total
      1145714570,42%
      2137628330,81%
      3103538681,11%
      660744751,28%
      758450591,45%
      854556041,60%
      952461281,75%
      1052166491,90%
      36073

      10,31%

       

      Can I do anything like that? I'm taking about the incremental count and the percentage.

      I know in the straight table you can take choose the first 10 or 30 elements (sorted as you want) but I'd like to do it in a pivot table.

      I want not to use too much code (statics table) in the script, because I'd like to let the user change the selections and modify the set of items anytime.

       

      Can you help me?

       

      Kind regards

      a