Sum of rows in straight table

[#1]

Hi,

i need a straight  table like this:

For example:

LOAD * INLINE [

    Category, Value

    A, 1

    B, 2

    C, 3

    D, 4

    E, 5

];

Table result

Category  Value

A                    1

B                    2

C+D                7

first4*               10

*first4 is the combination of A+B +C +D

in expression

=sum({$<Category={A,B  }>} Value)

work, but i don't know how  insert other selection ("C+D" and first4).

Thanks

Emiliano

[sunny_talwar]

Its a workaround, but this helps:

Table:

LOAD * INLINE [

    Category, Value

    A, 1

    B, 2

    C, 3

    D, 4

    E, 5

];

Concatenate(Table)

LOAD Sum(Value) as Value,

  'CD' as Category

Resident Table

Where Match(Category, 'C', 'D');

Concatenate(Table)

LOAD Sum(Value) as Value,

  'F4' as Category

Resident Table

Where Match(Category, 'A', 'B', 'C', 'D');

Output:

[#3]

Thank you sunindia

i will try this solution.

Emiliano