Hi Guys ,
Below is a interesting note between using Total and using Automatic summary for creating summary row.When you say aggregate it takes care of % and resolves percentages correctly .Check out below example
Notice that Total is giving me wrong values .But Summary is giving correct .Simple way to make total to give correct value is clicking on Percentage column and setting sort order as 2 .This solves it however if you use automatic summary the issue does not come at all .So next time you try to summarise go for Automatic summary
Below is a interesting note between using Total and using Automatic summary for creating summary row.When you say aggregate it takes care of % and resolves percentages correctly .Check out below example
Notice that Total is giving me wrong values .But Summary is giving correct .Simple way to make total to give correct value is clicking on Percentage column and setting sort order as 2 .This solves it however if you use automatic summary the issue does not come at all .So next time you try to summarise go for Automatic summary
No comments:
Post a Comment