Groupingcoloumns in report builder

[Anonymous]

Here is the report of excel same thing need to be done in report builder. Here the coloumn labels S is just a name under this i should get the first 8 months till aug and S total is nothing but sum of 8 coloumns  and Under F i need last 4 months till dec using month&year and F total . I should use matrix wizard. can someone help me out on this. Thanks in advance.

[v-yalanwu-msft]

Hi, @Anonymous ;

Sorry, I didn't understand what you meant, can you share a simple example and hopefully output the result (to make it easier to understand your logic)?

Please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.