Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Incorrect Subtotal& Grandtotal Paginated Report builder

Hi Everyone,   I have created a Matrix visual in Power BI report, which caluclates shows the sales& YOY growth percentage of regions. I have a requirement to build paginated report on this, I have...
Need Help
Show and Tell
Tips and Tricks
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Anonymous 

Please check this tutorial video. This video explains how to calculate the percentage of row and column totals in a Report Builder matrix. You'll learn how to alter the scope of aggregate functions to calculate row and column totals and compare these with the values in detail cells.

SSRS Report Builder Part 9.3 - Percentage of Matrix Row and Column Totals - YouTube

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.