3 of 3 people found this helpful
By default whatever the aggregation you are using on the measure, based on the aggregation the Grand total will be computed.
In your case when you're applying average for allowance for each day, the grand total is also taking the average of the values available on the columns.
You can change the grand total aggregation manually (sum in your case) by simply right click on the measure.
Hope this helps! Plz mark my response as correct if this solve your issue.
Thanks. It's working!