Inventory Managent

[jako1345]

We have an app that has a table of loads going out of our facility with multiple suppliers and products. On another table we have the same products coming in on rail with the same suppliers. Is there a way to have a table for each product and shipper with sums of each supplier and product. I need a view where I can view this inventory and download a report.  

[jako1345]

I have the following formula on a column for each one. 

SUM(
SELECT(
Load[Tons],
AND(
([Supplier] ="6"),
([Commodity]="Cotton")
)
)
)

It works for the filter on each but how to show this information has me stumped 

[dbaum]

UX view type: Dashboard - AppSheet Help