IceboundAphid
New Member
Hi,
I have the following scenario involving parents and children.
The Location table contains thousands of unique locations.
It has 3 columns – Location, Parent, Children
Some locations may or may not have a parent location, which is listed under the Parent column if applicable; blank if not.
Some locations may or may not have children locations, which is indicated under the Children column as a Y if they have children; blank if not.
E.g.
The location table has a one to many relationship with the Asset table, linked by the Location field. The Asset table contains many fields relating to each AssetID.
I have a slicer with the Locations[Location] field added, and filtered where children = 1. This shows that the location is a parent. This works correctly.
From there the requirement is that user will click on a parent location from the slicer, and it will list all AssetIDs for the parent location, as well as for each of it’s children location(s), and their children location(s) etc in a table.
I am not sure how to do this for nested children locations.
Can you please assist? Any assistance would be greatly appreciated.
Thank you
I have the following scenario involving parents and children.
The Location table contains thousands of unique locations.
It has 3 columns – Location, Parent, Children
Some locations may or may not have a parent location, which is listed under the Parent column if applicable; blank if not.
Some locations may or may not have children locations, which is indicated under the Children column as a Y if they have children; blank if not.
E.g.
| Location | Parent | Children |
| Melbourne | Y | |
| Richmond | Melbourne | Y |
| Smith St | Richmond | |
| Birchip | ||
| Manly | Sydney | Y |
| High Ave | Manly | Y |
| Sydney | Y | |
| Longley | ||
The location table has a one to many relationship with the Asset table, linked by the Location field. The Asset table contains many fields relating to each AssetID.
I have a slicer with the Locations[Location] field added, and filtered where children = 1. This shows that the location is a parent. This works correctly.
From there the requirement is that user will click on a parent location from the slicer, and it will list all AssetIDs for the parent location, as well as for each of it’s children location(s), and their children location(s) etc in a table.
I am not sure how to do this for nested children locations.
Can you please assist? Any assistance would be greatly appreciated.
Thank you