Solved: Make a pivot table - Page 2

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