Avg sum by quarter with set analysis

[#1]

I am looking to calculate an expression that takes the average sum of Spend for (fieldname) [Expense Type] = {'Airfare'} by quarter aggregated by Employee Name. Right now I have what is shown below, but I am not sure where to incorporate quarter field.

Avg(aggr(Sum({<[Expense Type] = {'Airfare'}>} AmountSpend),[Employee Name]))

[alexandros17]

try this

Avg(aggr(Sum({<[Expense Type] = {'Airfare'}>} AmountSpend),[Employee Name], Quarter))

and let me know

[sunny_talwar]

If you are using Quarter as your dimension, I don't really see why you would quarter in the expression. Have you tried this with Quarter as your dimension? Is it not giving you the expected output?

[ogster1974]

This document might help.

QlikView Technical Brief - AGGR

[#5]

It is within a straight table

[#6]

Thanks Alessandro, I want to say this worked but I am doing some QC checks first.