I need to arrange multiple columns in alignment beside each other for a specific requirement. Some columns require their totals to be calculated as a sum, while others need to display the average total.
However, whenever I select a different date or month, the average total automatically reverts to being set as "Automatic." Even if I manually change it to display the average, it switches back to "Automatic" once the date is altered.
Can someone assist me with this issue?
Hi @Sudarshan Dhiman
Thanks for the reply...
I cant use calculated filed. it has to be columns total sum / total average.
See the attached image. Yellow marked once are total average of the columns where as unmarked once are total sum.
But when i change my month and year. total by average changes to Automatic and shows different value in column total.
