Forum Discussion
How to do a calculation in the total row
Simple answer: Change the Aggregation in the Visual Setting from Sum to Average.
BUT, If the number you are aggregating is already a percentage, then it is usually NOT a good idea to show the "Average of the Percentage." Suppose you sell 500,000 of widget A at $1 each, and that average is $1. but you also sold 1 of widget B at $10. Your data may indicate that you have TWO averages, one per Widget type: $1 and $10. The Average of those two averages is $5.50 ($11 divided by 2). But the TRUE average is 500,010 divided by 500,001. To calculate that, you need the SUM of the Sales and the COUNT of Sales, and create a MEASURE that does that math with a DIVIDE statement.
Si
Super UserSimple answer: Change the Aggregation in the Visual Setting from Sum to Average.
BUT, If the number you are aggregating is already a percentage, then it is usually NOT a good idea to show the "Average of the Percentage." Suppose you sell 500,000 of widget A at $1 each, and that average is $1. but you also sold 1 of widget B at $10. Your data may indicate that you have TWO averages, one per Widget type: $1 and $10. The Average of those two averages is $5.50 ($11 divided by 2). But the TRUE average is 500,010 divided by 500,001. To calculate that, you need the SUM of the Sales and the COUNT of Sales, and create a MEASURE that does that math with a DIVIDE statement.
Si