grouping

[teobt14]

Hi there,

I want to group more records, for example I have a Safety Stock Level fields with the following records: 4,60, 100, 200 etc.

I want make a new group to include 4 and 60 and name it <100. Then I want to put all records in a pivot table.

How do I do that?

Thank you in advance!

[abhijitnalekar]

Hi @teobt14,

You can simply create a field on script level or create a variable like below

if(filed<100,'<100','>100') as Group