Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have below table
Estate_Code | Block_Code | Core_Code | Cluster_Code | UPRN | Asset_Level | Address | Post_Code |
ACO701 | NULL | NULL | NULL | NULL | ESTATE | NW6 5BA | NW6 5BA |
ACO701 | ACO603 | NULL | NULL | NULL | BLOCK | NW6 5BA | NW6 5BA |
ACO701 | ACO603 | NULL | NULL | 23021986 | PROPERTY | THE TIN TABERNACLE 12-16 | NW6 5BA |
ACO701 | CAM510 | NULL | NULL | NULL | BLOCK | NW6 5BA | NW6 5BA |
ACO701 | CAM510 | NULL | NULL | 58015470 | PROPERTY | FLAT A 18 NW6 5BA | NW6 5BA |
ACO701 | CAM510 | C1CAM510 | NULL | NULL | CORE | NW6 5BA | NW6 5BA |
ACO701 | CAM510 | C1CAM510 | NULL | 58015472 | PROPERTY | FLAT C 18 | NW6 5BA |
ACO701 | CAM510 | C1CAM510 | NULL | 58015473 | PROPERTY | FLAT D 18 | NW6 5BA |
ACO701 | CAM510 | C1CAM510 | NULL | 58116205 | PROPERTY | FLAT B 18 | NW6 5BA |
I am creating a matrix report the get the hierarchy like
now in the expand button if estate is selected it should show address,asset leve and post code of the estate on drilling down it should show the address of block and so on to UPRN. that is property.
and if there is no core and cluster then the UPRN should come directly under block.
Any help is appreciated
Thanks in advance!
User | Count |
---|---|
14 | |
10 | |
7 | |
6 | |
5 |
User | Count |
---|---|
30 | |
19 | |
12 | |
7 | |
5 |