Template Docs OrderBy()

[Izzat_Safrah]

Good Day,

I need help creating a template to print a table items report, order by location as a group.

The formula used in template does not give the desired result.

This is my table name "ITEMS LIST"

KEY	ITEMS	LOCATION	PCS
1	TV	Warehouse	15
2	Light	Warehouse	10
3	Shelf	Warehouse	6
4	Book	Shop	30
5	Headphone	Shop	45

---------------------------------------------------------------------

ITEMS REPORT

DATE: <<NOW()>>

<<START:ORDERBY(ITEMS LIST[KEY],[LOCATION],TRUE)>><<[LOCATION]>>

KEY	ITEMS	LOCATION	PCS
<<KEY>>	<<ITEMS>>	<<LOCATION>>	<<PCS>>

<<End>>

---------------------------------------------------------------------

I got a report for each item in a separate table

---------------------------------------------------------------------

I need a correct formula to display the report this way.

[Suvrutt_Gurjar · Accepted solution]

Here is a great tip by @Aleksi 

Grouped list from one table - Google Cloud Community

Another nice one by @Marc_Dillon 

Single category headers in workflow templates for ... - Google Cloud Community

[Suvrutt_Gurjar · Accepted solution]

Here is a great tip by @Aleksi 

Grouped list from one table - Google Cloud Community

Another nice one by @Marc_Dillon 

Single category headers in workflow templates for ... - Google Cloud Community

[Tommy62]

DATUM: <<NOW()>>

<<Start:FILTER(“ITEMS LIST”,[.KEY]=MAXROW(“Device List”,“_Rownumber”, [SPEICHERORT]=[_THISROW-1].[SPEICHERORT]))>><<SPEICHERORT>>

.KEY	ARTIKEL	ORT	PCS
<<Start:FILTER(““ITEMS LIST”, [SPEICHERORT]=[_THISROW-1].[SPEICHERORT])>> <<[.KEY]>>	<<GEGENSTÄNDE>>	<<LAGE>>	<<PCS>><<END>>

[Izzat_Safrah]

@Tommy62 

I will try your idea thank you for help 🙂

[Izzat_Safrah · Accepted solution]

---

@Suvrutt_Gurjar wrote:

Here is a great tip by @Aleksi 

Grouped list from one table - Google Cloud Community

---

Thank you so much @Suvrutt_Gurjar   . I go with @Aleksi  His idea works perfectly 👍

1- This what i did. Create a Virtual Column's name [GROUP]

2- With this formula

3- And formula on template

4- And this what i was looking about