[REPORT BUILDER Help] Nested Subtotal

Hi slap33 ,

Follow the steps below to create a table or matrix visual in your reporting tool:

1.  Create a New Report

      Click on "New Report" to begin the report creation process.

2.  Select the Visualization Type

     Choose the "Table/Matrix Visual Wizard" to proceed with the structured data representation.

3.  Choose or Create a Dataset

      Select an existing dataset or click on "Create Dataset" (located at the bottom left).

  Click "Next" to proceed.

4.  Establish a Data Connection

     Click on "New" to create a new data connection.

  Select the desired connection type:

     In this example, the "Enter Data" option is selected. Alternatively, you may choose "Microsoft SQL Server" or another preferred data source.

    Click "OK" and then "Next" to continue.

5.  Enter Data

  Input the required data manually (if using the "Enter Data" option).  Click "Next" to proceed.

6.  Configure Row Groups and Values .In the Row Group section, select:

     Club

     Budget

In the Values section, assign:

     Joueur

     Salaire

7.  Adjust Layout Settings

     Select the option "Blocked, Subtotal Below" for proper data structuring. Click "Next" to proceed.

8.  Finalize and Execute the Report . Click "Finish" to complete the setup.

Run the report to view the final output.

Hello slap33 ,

Apologies for the delay in getting back to you.

It looks like the issue you're facing is very similar to one that another user encountered earlier. That issue has been resolved, and the solution might be helpful in your case as well.

Please refer to the post linked below for the full explanation and steps:

Solved: Report Builder Nested SUM ( IIF Question - Microsoft Fabric Community

How do I calculate subtotals in paginated reports based on certain values? - Microsoft Q&A

 If these don’t help, I recommend raising a support ticket with Microsoft for further assistance.

Below is the link to create Microsoft support ticket:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy