How to show just one record in AGGR?

[hamy_IT_Dev]

Hi

I have this table:

tblCustomer:
LOAD * INLINE [
Customer, Value
A, 20
A, 30
A, 40
B, 10
B, 15
C, 40
C, 55
D, 101
D, 102
D, 103
D, 104
];

I have created a straight table
Dimension: Customer
Expression: Sum(aggr(Sum(Value),Customer))

in result I have all customer

but
How to show just one record when Customer = C ?

[tresesco · Accepted solution]

Try like:

Dimension: Customer
Expression: Sum({<Customer={'C'}>}Value)

You don't need aggr() here.