# App Development

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for
Did you mean:
Contributor

## SUM the total revenue of a customer in a table by ignoring product sub-set

I want to make Table1 in App. (I don't want to make it as Pivot.)

it is easy to get 2020 Revenue @ Customer & Product.

how should I get 2020 Revenue  @ Customer ?

Table1

 Customer Product 2020 Revenue @ Customer & Product=SUM({\$})Revenue 2020 Revenue @ Customer A P1 =200+400+800+1600 =200+400+800+1600+100+200+400+800 A P2 =100+200+400+800 =200+400+800+1600+100+200+400+800 B P1 =2000+4000+8000+16000 =2000+4000+8000+16000

raw data

 Customer Product Revenue Year Quarter A P1 100 2021 Q1 A P2 50 2021 Q1 B P1 1000 2021 Q1 A P1 200 2020 Q1 A P2 100 2020 Q1 B P1 2000 2020 Q1 A P1 400 2020 Q2 A P2 200 2020 Q2 B P1 4000 2020 Q2 A P1 800 2020 Q3 A P2 400 2020 Q3 B P1 8000 2020 Q3 A P1 1600 2020 Q4 A P2 800 2020 Q4 B P1 16000 2020 Q4

Thanks

1 Solution

Accepted Solutions
Contributor
Author