Expression Average Total in Pivot

[#1]

Hi,

I have a pivot chart with expressions that calculates the average customer visits as per the below formula:

avg(aggr(Count({$<DocType={'3'}>} DISTINCT CustCode),SmCode,Date))

My problem is that the total (partial sum) is not being calculated properly as it doesn't count the dates that have zero visits as shown below:

can you pls help me that?