Solved: Re: Make a pivot table

SGMP_AKBP1 · 12-28-2021 03:01 PM

Hi, Greetings

I am Denny, pleased to join you
I have practiced through trial and error
in appsheet, in such a challenge in my
2nd quarter of life.

I have a question, and if it has been added as a Thread before
, it would be great helps for me if I would be guided to where it was

The Problem is how do i make a pivot table, in my
PDF file such as this

Thank You for your time and advise
Best Regards

SGMP_AKBP1

All praise to God and thanks to you, I have found the solution, at least for now…

this is link to my google docs

this is my expression:
<<Start: FILTER(skld, AND([No Surat]=[_THISROW].[No Surat], [In-Out]=”In”))>>…<<'End>>

<<Start: FILTER(skld, AND([No Surat]=[_THISROW].[No Surat], [In-Out]=”Yes”))>>…<<'End>>

Note: remove the “’” at the word “End”

So there are two tables, the one above only includes Cash In only fund and the below one includes Cash out only

perhaps, these lines could help anyone who read it

View solution in original post

SkrOYC

Outside AppSheet I guess…

You can’t

SGMP_AKBP1

With google Docs? or would you mind, showing me where to i must learn

WillowMobileSys

There are ways to create the pivot table in both AppSheet and in templates. They both will need some advanced implementation.

If your goal is to generate a PDF then you will want to use templates…and yes Google Docs is the place to start. I would recommend getting familiar with how to create a template. This link below will show you a list of articles to start with:

As for creating your pivot table in a template, you will need to use nested START blocks. However, the hurdle you will likely run into is naming clashes - i.e. where you have the same column name in multiple tables/datasources. If you are willing to rename columns when needed then this shouldn’t be an issue.

Here is the general idea to create the pivot table in a template

Create a START block that provides a list of departments. If you have a table of Departments then use that to kick off the template.
Inside of the START block in 1) create a second START block that provides a list of your data rows. You will need to filter by the Department from the outer START. This is where the name clash can happen. Using [Dept] = [Dept] will not work. You can avoid this clash with different column names between the sources - e.g. [Department] = [Dept]
Use template tables to control the formatting of the data.
You can use IF statements in the template to conditionally show things if needed.

SGMP_AKBP1

I guess this is the lead i wanted, thank you for your kindly sugestion, i will follow up your pointing

best regards

WillowMobileSys

Yes, try it first but don’t spend too much time playing around and getting frustrated. If you get stuck, even a little, come back here and ask your question. That’s part of what this Community is about - saving you time in figuring out how to build things, Short of doing the work for you…who can learn anything that way!

SGMP_AKBP1