Aggregation data in Pivot table

[Daniele3]

Hello everyone, I am new to programming with Qlik and I need help with a request that was made to me.

I have a pivot table with data written in a format similar to this:

GROUP | VALUE

210           1000
220           2000
230           3000
310           1000
320           2000

I would like to aggregate the values ​​in the format:

GROUP | VALUE

200          6000
300          3000

And, expanding the data, clicking on the "+", then see the subdivisions in the following way:

GROUP | VALUE

200           6000
- 210        1000
- 220         2000
- 230         3000
300           3000
- 310         1000
- 320         2000

Can anyone suggest a method to do this?
Thanks in advance

[QFabian]

Hi @Daniele3 , here an option, creating the additional field in script :

Data:

Load //precedent load

     *,

    floor(GROUP / 100) * 100 as Level_1;

Load * INLINE [ //your data

GROUP, VALUE

210, 1000

220, 2000

230, 3000

310, 1000

320, 2000

];