Generate Report Related to Grandfather Table

[AbdullaNsour]

I need help generating an Excel report in AppSheet that displays all the Electricity meters related to a specific Transformer. Here’s the scenario:

The Service table has a column called Electricity meter, which lists the electricity meters associated with that service.
The Transfo

rmer table has a column called Service, which links to the services associated with the transformer.
What I want is an Excel report that, when I generate it for a specific Transformer, will list all the Electricity meters from the Service table that are linked to the Related Services for that transformer.

How can I create a report in AppSheet that pulls all the related Electricity meters from the Service table and displays them in the Transformer report?

Transformer have many Service and the Service have many Electricity

Service

Service_ID	Service no.	Transformer	…	…
<<Start: [Related Services]>><<[Service_ID]>>	<<[Service no.]>>	<<[Transformer]>>	<<[…]>>	<<[…]>><>

Electricity meter

ElcM_ID	Electricity No.	Service	…	…
<<Start: [Related Electricity meters]>><<[ElcM_ID]>>	<<[Electricity No.]>>	<<[Service]>>	<<[…]>>	<<[…]>><>

what I need something like this :

Electricity meter According to Transformer

Transformer	Service No.	Electricity No.	…
Tr1	service 1	Elc-1	…
Tr1	service 1	Elc-2	…
Tr1	service 2	Elc-3	…
Tr1	service 2	Elc-4	…
Tr1	service 3	Elc-5	…
Tr1	…	…	…

I hope the matter is clear

[TeeSee1]

I do not work with Excel but the help document says nested tables are not supported.

So it seems that your option is to create a report table that has all the data required and use that for reporting.

Others may have other suggestions.

[TeeSee1]

I’ve given it another thought and an idea hit me.

Try this and should work.

Transformer	Service	Meter	Measurement1
<<Start: ORDERBY(Filter(“Meters”,[ref.Service].[ref.Transformer]=[_THISROW]),[ref.Service].[name.service],FALSE,[name.meter])>><<[ref.Service].[ref.Transformer].[name.transformer],FALSE>>	<<[ref.service].[name.service]>>	<<[name.meter]>>	<<[measurement1]>><>

A result:

Transformer	Service	Meter	Measurement1
TRF01	Service 01	meter 1-1	100
TRF01	Service 01	meter 1-2	20
TRF01	Service 02	meter 2-1	50
TRF01	Service 02	meter 2-2	30

Hope this helps