0 Replies Latest reply: Jul 18, 2011 8:47 AM by Marco Martinez RSS

    Problem Analysis Set min function in pivot table

    Marco Martinez

      Hello!

      The table shows a number of families with their items, you can see we have three columns, the first shows the minimum time for each item, the second is a summation of the field quantity and the third makes us a summation of the minimum amount on the date per item (sum ({$ <Date = {$(='"<='& min (Date )&'"')}> Number})) the problem we see is that this makes the minimum set of items in rather than for each item, ie for each line.

       

      In what way can we do this for us to take the minimum time per item?