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({$<YEAR={2020}>})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
