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 |
---|---|
39 | |
28 | |
23 | |
23 | |
13 |