SSRS / PBIRS report grouping category sub category / share % at parent level

[DeepDive]

Hi all, can you please guide me on how to create the below type of report in ssrs or pbirs. I need to achieve same type of format. In which I want to show top customers under category then, top customer under sub category (in which i want to show brand on one particulat customers ) .. need share % of measure at their parent level :

[saglamtimur]

There is no magic tool that creates this format easly. If you can share some test data I can play with it.

If my post solved your problem, mark my post as a solution to help others to quickly find it and also please give it a 👍

[DeepDive]

Hi @saglamtimur , Kindly find below the link for Excel file.

https://www.dropbox.com/scl/fi/d1hw2hlacsa7w0xs9bkfo/SalesPI.xlsx?dl=0&rlkey=gxqgwn6e790s0u4vipl3kr7...

Thanks

[DeepDive]

Hi @saglamtimur and others, any suggestions would be highly appreciated. 

Thanks

[saglamtimur]

OK, I will play with it when I have time.