Total by selected dimensions except one

[Daniel_BI2024]

Hi All, 

I have the following formula, and I want to get the total campaigns' installs without the events split.

the formula is: 

sum( total<campaign_number> {<action_name= >} Installs)

for this example, the campaigns' total installs are: 3,000

the installs per event:

purchase: 500

add to card: 1000

order:1500

I'm getting a correct installs per campaign, but when I choose specific event I missing  installs, it means that when I Choose 'purchase' and 'add to card' I'm getting only 1,500 installs and I want to get all the 3,000 installs.

Appreciate it a lot if someone can help me to solve it!

[Daniel_BI2024]

Hi,

My question above is still relevant, I haven't solved it yet.

Thanks in advance for any assistance, I appreciate it a lot!