Actually, I want one formula for three branch

[eoshila]

I have four tables, three tables for my three branches & one for Reports.

1. Jaudat Jamuna
2. Paddo Priol
3. Bihot Bazar
4. Report
   Every branch has the same product for sales.
   Like:
5. BBQ Mini
6. Cheesy Burger
7. Chicken Sandwich
   I wrote the formula for calculating product sales quantity by filter-branch & product with between dates. By the below formula I can see all Jaudat Jamuna sales. Now I want to see in the same row with individual branch reports by upgrading the below formula. Please help me to add
8. Paddo Priol
   &
9. Bihot Bazar
   SUM(SELECT(Jaudat Jamuna[BBQ (Mini)],or(and([Date]>= [Start Date], [Date] <= [End Date],[Order From]=[Order Type]), and([Date]>= [Start Date], [Date] <= [End Date],[Order Type]=“All”)))),

Actually, I want one formula for three branch

[shahappsheet]

I am scared it is not possible in appsheet as table name can not be variable or multiple table can not full join. So, I think you need to do it separately or you can merge the table manually adding additional field “BranchName”. Then you can prepare report using single query.

Best of luck.

[eoshila]

Thanks @shahappsheet

I think so. Thanks for your suggestion.

[VOLODYMYR_TYROL]

Hi it’s call “Partitioned across many files”

help.appsheet.com

Scaling Using Data Partitions

How to use data partitions to improve performance at scale.

but Data partitions feature available with Enterprise plans only.