set analysis expression

[#1]

Hello

There is simple dataset

Data:

LOAD * INLINE [
Name, Value
A, 10
B, 20
C, 30
];

Need to create stright table with such results

The problem is to write the expression for “Value ProductB”

It is just the Value of Prosuct B

Product	Value	Value ProductB	Comparison
A	10	20	-10
B	20	20	0
C	30	20	10

Let me know if you know how

[sunny_talwar · Accepted solution]

May be this

Dimension

Name

Expressions

Value

Only(TOTAL {<Name = {'B'}>} Value)

Column(1)  - Column(2)

[#3]

Thanks,works!