Forum Discussion
[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-ticketIf 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
Hi slap33 ,
Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.
One important thing is missing and that's what i'm looking for : the grand total of 110.
As the field is set in the Row Group section, i guess it is considered as an attribute and it can't be sum ?
Like in a pivottable, i guess the budget i need to sum needs to be in the detail values part. And there i gonna have my duplicates back again.
I'm afraid the only to do the job is to create a subreport (agregate) to import in the main detailed report.
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-ticketIf 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