How to 'Group By' a Dimension values in Straight Table?

[abc_18]

I have a straight table like below created in Qlikview.

requirement is to group the values in this table, Only "p-2" and "p-3 & below (p-4, p-5, p-6..)" should be populated on this table.

For "p-3 & below" row, this will show the aggregate of "p-3" and lower values only.

Number - update	p	Total
20.0.15344-No update	p-6	4
20.0.16554-Update on Oct	p-4	5
20.0.17456-Update on Dec	p-3	12
20.0.17457-Update on May	p-2	234
20.0.18657-Update on May	p-1	125
10.0.18658-Update on Sept	p	78
5.1.4567-June update		90

Please suggest how can I achieve this.

[Mark_Little]

Hi @abc_18 

I would create the Aggr field in the script with an if statement. Then you can use that instead.

[abc_18]

Hi Mark,

Can you please elaborate more on this?

These fields are directly coming from a table with the values like 

Load*,

Number

update 

P from XYZ;

P having values as (p-1, p+, p+2, p+3,p-2, p-3, p-4, p-5, p-6....)

Number column having values as 20.0.17456-, .... and Update column having values similar to Update on May like these...

and Total I am calculating at expression level.

How to write aggr for this, tried using it in from end at chart level but it didn't work.