Straight table blank fields - using set analysis

[#1]

HI all

I am having issues with a table. I cant make data show in Avg B or Avg C columns. The data only appears in Avg B or Avg A when i select an individual month using a 'Month' List box.

I can't understand why i have to select a month for the data to appear.

Month	Avg A	Avg B	Avg C
Dec11	652	889	827
Jul12	598	-	-
Jun12	605	-	-
Aug12	685	-	-

Avg A formula = Avg(Rank_1_Premium)

Avg B formula = avg(aggr(Max({$<[Insurer]={'eCar'},[Premium]={'<99999'}>} [Premium]) ,RiskNo))

Avg C formula = avg(aggr(Max({$<[Insurer]={'Asda OE'},[Premium]={'<99999'}>} [Premium]) ,RiskNo))  

Can you help?

J

[whiteline]

Your data that you use to calculate this expression.

The numers and string values are obsolete you can scrable them.

The table structure is important.

[whiteline]

Obviusly the problem is in wrong aggregation.

One right result can be explaind easily.

Possible there is only one record of RiskNo in Dec11.

[#4]

Here is the test data

[whiteline · Accepted solution]

Oh, I've got it.

You discard Month dimension during aggregation.

Use this kind expression:

=avg(aggr(Max([Premium]) ,RiskNo, Month))

[#6]

Perfect!!

thanks for your help. I knew it would be something as simple as that.

But as they say, it's not simple unless you know how!!

Thanks!!!

[whiteline]

You are welcome.

Sorry, for so long way.

Just check the right answer to close the question.