Create a data summary table like (PivotTable in Excel)

[SirajAMS]

I have sample table

|item| |Qty.| |date|

|Item 1 |1 |1/1/2021|
|Item 2 |1 |1/1/2021|
|Item 3 |0 |1/1/2021|
|Item 4 |0 |1/2/2021|
|Item 1 |1 |1/2/2021|
|Item 2 |0 |1/2/2021|
|Item 1 |1 |1/2/2021|
|Item 2 |1 |1/3/2021|
|Item 3 |1 |1/3/2021|
|Item 4 |0 |1/3/2021|

I want to create a data summary table like (PivotTable in Excel)

|Row Labels| |Sum of Qty.|

|Item 1| |3|
|Item 2| |2|
|Item 3| |1|
|Item 4| |0|

What is the method for that? So that I can use it in UX

[Aurelien]

Hi @SirajAMS

Pivot Table in AppSheet are not available.
Instead, you could use groups (such as the option in view type Table) and aggregate calculations.

For further needs requiring specifically pivot table features, you should try Google Data Studio.

[Koichi_Tsuji]

I reckon you are using Google Spreadsheet as data source.
Then create the pivot table out of your data set. Create pivot with new sheet.
You are not able to read this sheet where pivot table expression inside the sheet for AppSheet table.
Then create additional sheet. On this sheet, you call data from pivot table sheet, using IMPORTRANGE() expression which is provided by Google Spreadsheet.

Then read this sheet as table from Appsheet.

You will see the summary (pivotted table) as you want.

This is one of the most easy-peasy workaround.

[Aurelien]

I didn’t think about the most obvious possiblity, thanks @tsuji_koichi for pointing this out

[Koichi_Tsuji]

You are welcome.

[Koichi_Tsuji]

We can employ this technique here and there, as far as the dynamic pivot table will not add Column, the number of the column static.