Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
Thank you sunindia
i will try this solution.
Emiliano