KPI calculation question

[Anonymous]

Hi all,

Sorry to bother you but I am struggling with this issue and I can't do what I want.

I have a fact table that looks like this :

Action ID	Ticket ID	Sales	Discount sales
A	1	-	5.99
A	2	-	6.99
-	1	11.98
-	2	17.98
-	3	35.99

I want to create a chart table with the following result :

Action	Sum of sales for total tickets linked to an action id
A	29.96 (=11.98+17.98)

Can someone help me write the formula of the expression to get this result please ?

Thanks in advance,

Regards,

Sophie

[Anonymous]

Thanks a lot