If identical dates and id then sum

[Qliksense_77]

Hi,

I have data like below . The red text shows the measure that i am searching for.

When id and dates are identical, and the names starts with "b*" and "c*", then I only want to sum rows where name starts with "c". 

Can somebody help?

Id	Date	Name	Value	Sum
1	10-10-2020	a*	1	1
2	11-10-2020	b*	2	2
3	12-10-2020	b*	3	0
3	12-10-2020	c*	4	4
4	13-10-2020	a*	5	5
4	13-10-2020	b*	6	6

[OmarBenSalem · Accepted solution]

try this :

if(index(concat (distinct total <Id,Date> Name),'b*')>0 and
index(concat (distinct total <Id,Date> Name),'c*')>0,sum({<Name={'c*'}>}Value),sum(Value))

Result :

[Qliksense_77]

Perfect, thanks😀