Display matrix of data using PATH function without step duplication when drilling

Hi, Using data from an asset management software, I have been asked to display financial data in an exacting manor compared to the source software.  In the source, we have account trees and these tr...