AGGR average only on total line

[#1]

Hi All

I have the following expression in a straight table with a single dimension.  The problem I have is that the result only shows on the total line - i don't get averages per value in the dimension? Please can anyone advise?

Avg({$<[Fiscal _DateSerial]={">=$(vL.12MthRolling)<=$(vL.Period)"}, Type={'Non Pay'}>} aggr(sum({$<[Fiscal _DateSerial]={">=$(vL.12MthRolling)<=$(vL.Period)"}, Type={'Non Pay'}>} #Balances_In_Month_Actual),[Fiscal Year-Month]))

Thanks

Dominic

[vgutkovsky]

Well, what are the chart dimensions (in order)?

Vlad

[#3]

The only dimension is SubType a

Lower granularity grouping.

[vgutkovsky · Accepted solution]

Add SubType to your aggr in that case, in addition to Fiscal Year-Month.

Vlad