Problem LINKTOFILTEREDVIEW

Sid13
New Member

Hello,

I hope to have some help because I am blocked for several days.
I want to use LINKTOFLITEREDVIEW to switch from a โ€œMAINTENANCEโ€ view to an โ€œINVENTORYโ€ view but with a filter.
In โ€œINVENTORYโ€, I have a โ€œCODE DIโ€ (type Ref) information which contains the same information as โ€œId Objetโ€ (Type ref) in โ€œMAINTENANCEโ€.
I tried to do this:
LINKTOFILTEREDVIEW(โ€œInventoryโ€, IN([CODE DI], SELECT(Inventory[CODE DI], [Id Object] = ([_THISROW].[Id Object]))))
But it doesnโ€™t work, it sends me back to โ€œINVENTORYโ€ but without filter.
Could you please help me and tell me where I am wrong?

Thanks in advance

0 3 109
3 REPLIES 3

Is this what youโ€™re wanting?

LINKTOFILTEREDVIEW( "Inventory" , [CODE DI] = [_THISROW].[Id Objet] )

Sid13
New Member

Thank you for your help, I tried but it does not work, it makes a white screen

Sounds like there arenโ€™t any records in inventory where the [CODE DI] value matches the [Id Object] value from the record you ran the LINKTOFILTEREDVIEW from. Are there?

Top Labels in this Space