I agree, it is hierarchical column but user doesn't want to open each level. When report runs default all level should populate as shown above.

Unfortunately that is the requirement.

Hi Christian, Apologies for the confusion and delayed response. I don't have the solution yet. Attached are my table structures and the expectation is to show all the Accts (child's and then respective parents). Hope it gives better understanding of requirement. Thanks again, Nag

Hello gurus any suggestions?

Thanks again Christian. I looked into this, my requirement is little different, i.e., I don't want hierarchal view and then click + symbol to expand to see further. When I place acct column with measure, it should aggregate to all the levels and also we are going to create filters using this column. Thanks Again for you…

Thanks Christian, Robert for your quick reply. My Account table structure: My Fact table has data at leaf level. I am trying to create a report looks as below I hope I gave the requirement , let me know if it is not clear. Thanks, Nag