avg of the sum of the last 3 months

[Ruth_Landa]

I'm trying to calculate avg of the sum of the last 3 months aggregating models, catalogs, using the next variables 3M_Periodo like Period, 3M_Modelo like Model, Catalogo like Catalog and 3M_total_cat like total units...when I compare the sum it is correct, but when I compare applying the avg, the numbers doesn't match.

• In this case, I calculate it using a pivot table:

• But in qlik sense, D3C = 3, D5A = 12, D6S = 9, using the next formula: avg(aggr(Sum([3M_total_cat]),[3M_Periodo],[3M_Modelo],[Catalogo]))

Thanks,