REF_ROWS two levels deep
Letโs say I have a customer with multiple premises, each premise possibly having multiple installations. On the customer, I can show the premises by using REF_ROWS. Is there a way to show the installations directly on the customer (essentially creating a REF_ROWS two levels deep)?
I tried:
FILTER(installations, IN([premise_id], SELECT(premises[premise_id],[customer_id] = [_THIS].[customer_id])))
But this does not work, error:
Error in expression โ[_THIS].[customer_id]โ : Unable to find column โ_THISโ
Any ideas?
I would put a helper column in the installation table that carries the customer id dref to the premises tableโฆ
Then just select off of that
Simple but effective, thanks @Grant_Stead
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |