topic SSRS / PBIRS report grouping category sub category / share % at parent level in Report Server

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

DeepDive — Fri, 17 Jul 2020 10:34:48 GMT

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 :

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

saglamtimur — Fri, 17 Jul 2020 11:57:54 GMT

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 👍

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

DeepDive — Fri, 17 Jul 2020 14:39:19 GMT

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

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

Thanks

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

DeepDive — Sat, 18 Jul 2020 09:26:46 GMT

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

Thanks

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

saglamtimur — Mon, 20 Jul 2020 06:13:20 GMT

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