How do we view pivot data sheet info in appsheet

Hi want to view my sales data for which I have created a pivot table on google sheets, by month and salesman wise.

How can I enable to view this data on appsheet

Hi, unfortunately we do not support updates to tables containing pivot tables.

i think i saw another blog in this community where they showed a way of viewing the pivot table via link shared from the google sheet…we can create a seperate table and put iin the URL…from here we can directly view the pivot table via the link…

Have you looked into Gsheets transpose()?

https://support.google.com/docs/answer/3094262?hl=en&authuser=0