Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Add SubType to your aggr in that case, in addition to Fiscal Year-Month.
Vlad
Well, what are the chart dimensions (in order)?
Vlad
The only dimension is SubType a
Lower granularity grouping.
Add SubType to your aggr in that case, in addition to Fiscal Year-Month.
Vlad