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
<>	<>	<>	<>

<>

---

I got a report for each item in a separate table

---

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

[Suvrutt_Gurjar]

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]))>><>

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

[Izzat_Safrah]

@Suvrutt_Gurjar

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

[Izzat_Safrah]

@Tommy62

I will try your idea thank you for help