I was hoping the calculated field of Column D / Column A would calculate the same way in the totals, but it seems totals calculate vertically only. Any tips to get the total to work like the screenshot?
@Kashgar - Thank you for posting your query. It seems that you need to ensure that your column D calculation aggregate properly is custom instead of sum. Ideally if you create the calculated expression properly with necessary aggregation in place, that would automatically percolate in the totals as well. Please see the sample snapshot highlighting the same. Hope this helps!
Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!
1 Like
Thanks @sagmukhe!
You were right, it wasn’t calculated correctly and a bit obvious now. Once changed it visualizes as expected.
2 Likes