Calculated Dimension and Aggr()?

[#1]

Hi there,

I am trying to build a report which requires me to create a calculated dimension, and wondering if one of you guys can help me.

Below are my dataset and desired result. Basically, I would like to create a dimension whose members are ">" and "<=" . Note that ">" correponds to observations in the datasets whose sum of Value 1 is greater than Value 2. Similar idea apply to "<=".

Any help will be greatly appreciated. Thank you.

DataSet:

Dim_01	YYYYMM	ID	Value1	Value2
AA	201303	1	1	29
AA	201303	2	92	88
AA	201305	1	76	37
AA	201305	2	2	73
AA	201307	1	10	1
AA	201307	2	98	7
BB	201303	3	58	40
BB	201303	4	91	50
BB	201305	3	25	10
BB	201305	4	45	83
BB	201307	3	10	43
BB	201307	4	74	5
CC	201304	1	40	47
CC	201304	2	64	46
CC	201306	1	39	9
CC	201306	2	62	11
CC	201308	1	26	13
CC	201308	2	76	6
DD	201304	3	51	96
DD	201306	3	1	98
EE	201304	4	4	20
EE	201306	4	1	69

Desired Result

Dim_01	Value1 vs Value2	Avg. Value
AA	>
	<=
BB	>
	<=
CC	>
	<=
DD	>
	<=