Hi,

Is it possible to group some records in a list window, without using the temporary table (A temporary table can't be used, because of the great amount of data)?
The difficulty is that depending on the kind of data, an other grouping selection is needed:
If detail costs are 'Material', then group by index1, except the sequence,
If detail costs are 'Internal effort', then group by index1, except the order and operation.

Thanks,
Berthe Daeveloose

Did you try to use 'View Fields' in DFE?

You can also explore with 'Indices by Session' which has the sort & view fields options.

Some records should be grouped and their amounts should be summed.
For example:
the lines
Material Order1 pos1 seq1 qty1
Material Order1 pos1 seq2 qty2
Material Order2 pos1 seq1 qty3
Material Order2 pos1 seq2 qty4

should become
Material Order1 pos1 qty1 + qty2
Material Order2 pos1 qty3 + qty4

I don't think this can be done by using 'View Fields'?
It's not the sorting whitch should be changed, so indices by session can't be used either.