How to get matching data from one report and compare to another
Hi,
I am trying to search the uploaded data in Report B for matching rows in report A and get a sum of the records in Report B that match the Luxury column criteria in Report A.
Report A contains the Luxury column criteria that is hidden in Report B, but we need the matching companies in rows with “Yes” in the luxury column Report A summed up in the form after they are uploaded.
Report A
|
Company Sub-Type |
Luxury |
Company Name |
2023 Sales |
2022 Sales |
|
Services |
Yes |
Test Company 1 |
5000000 |
61000000 |
|
Services |
No |
Test Company 2 |
3000000 |
41000000 |
Report B
|
Company Sub-Type |
Company Name |
2023 Sales |
2022 Sales |
|
Services |
Test Company 1 |
5000000 |
61000000 |
|
Services |
Test Company 2 |
3000000 |
41000000 |
Help is greatly appreciated.
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Zoho Orchestly Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー