In Pivot i am displaying max values by using below expression
max(aggr(sum({<Date={">=$(=WeekStart(Today(),-5)) <=$(=WeekStart(Today(),-1))"},name={'C'}>}value), Brand,name,Date)) and i am getting correct values but when i am displaying total it is giving total as max num ,instead of summing up all max values
brand name max
A C 10
B D 20
Here i am trying to display column level total as 30 instead of 20
