Help with Summary Expression

[#1]

Can you guys please help with this summary expression. I'm completely stuck.

I have a table that has 3 columns - ItemCode, Ownership, Value. An ItemCode can have one ownership or multiple ownerships. I need to create a bar chart with Ownership as the dimension and the total Value of all ItemCodes that have more than one ownership as the expression.

Here is what I did -

Dimension is just the Ownership column

Expression is...

sum(aggr(If(Count(distinct [Ownership])>1, sum(Value),0.00),ItemCode))

This expression is unable to break apart the Value for each ownership dimension

Any suggestions will be greatly appreciated. I'm attaching the QVD for your reference.

[#2 · Accepted solution]

sum({<ItemCode={"=count(ItemCode)>1"}>}Value)

[#3]

Thanks very much Richy...This is exactly what I was looking for...Thanks again!