report pdf template

[Oscar_Rossini]

I have a table called inventory, with the columns: item, department and image

I make a bot to generate a PDF file, I did it, but when I want to separate by the department column value, of the enum type, I can't do it, I've tried with Select, but I can't... can someone help me?

[Marc_Dillon]

---

@Oscar_Rossini wrote:

I want to separate by the department column value

---

What does that mean?

[Oscar_Rossini]

hi
i am sorry, my english is very bad ....: (

I need to report the list of items for each of the values in the department column

Table: inventory

item	department	image
Beer	Drinks	image1
shampoo	Clean	image2

This is the template that I have made, but it lists all the items of all the departments

[Marc_Dillon · Accepted solution]

FILTER( inventario , [departamento] = [_THISROW].[departamento] )

[Oscar_Rossini]

thanks !!!