Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks a lot