Pivot table in App sheet

[CatalinaK]

Hi! I want to create smth that looks the same like a pivot table in app sheet or to put my pivot table from google sheet in app. How can I do this? Thank you

[jyothis_m]

Please see this POST 

[CatalinaK]

How I create a static table with same structure as the PIVOT Table (Column Names as you want in the App and Rows in First Column with the items to be shown in summary)

[jyothis_m]

By static table i meant a normal Appsheet Table. Since pivot table column names might change based on the settings, if its directly linked to appsheet, it might make the complete app not to run. Hence the same Pivot Table copy is made in another table with fixed column named which does not change. Data of this table is read from pivot table by vlookup.

[AleksiAlkio]

I played with this and how to make it without any sheet formulas and the result is this

The idea is to have fixed rows for each location and then modify Qty and Total values with actions when the new row is added or modified.