Hey, I have a problem with Template filter.....

Hey,

I have a problem with Template filterโ€ฆ i have: - A table with a list of clients โ€œClientsโ€ - A table with clientโ€™s orders (all clientโ€™s orders in the same table) โ€œDispatchโ€ - A slice with the last month Orders โ€œmois_dernierโ€

I want to display the order of each clients of the last month:

<<Start: And(Filter(mois_dernier, TRUE),Filter(mois_dernier[nom_client]=Clients[nom_client],TRUE))>>

have a problem

any idea? thanks

0 3 318
3 REPLIES 3

<<Start: filter(mois_dernier,[_THISROW]=[nom_client])>>

look like good not ?

<<Start: AND(Filter(mois_dernier, TRUE),SELECT(mois_dernier, [_THISROW] = [nom_client]))>>

not work aswell

<<Start: filter(mois_dernier,[THISROW]=[nom_client])>>

[nom_client] was missing in the slice

thanks

Let me checkโ€ฆ do you want to have one template with all orders from the last month?

Top Labels in this Space