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
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |