Aggregated expression

[jessica_webb]

I have a very large table with the following 3 dimensions 

and 6 expressions:

ID	Type	Set	SUM({<GEN={'ALL'}>}NUM)	AGGR(NODISTINCT SUM({<GEN={'ALL'}>} ID	AGGR(NODISTINCT SUM({<GEN={'ALL'}>} NUM),Type_Set)	SUM(TOTAL {<GEN={'ALL'}>} NUM)	SUM({<GEN={'ALL'}>}NUM)/AGGR(NODISTINCT SUM({<GEN={'ALL'}>} NUM),ID)	AVG(SUM({<GEN={'ALL'}>}NUM)/AGGR(NODISTINCT SUM({<GEN={'ALL'}>} NUM),ID))
123	A	NAERG	33	1794	41073	5544553	0.0184	0.019246154
123	A	BZFAW	57	1794	180841	5544553	0.0318	0.019246154
123	A	AQEGA	64	1794	152782	5544553	0.0357	0.019246154
123	A	HSSMFM	15	1794	27766	5544553	0.0084	0.019246154
387	A	AEGGV	10	1729	707	5544553	0.0058	0.019246154
387	A	ASDFBT	12	1729	36537	5544553	0.0069	0.019246154
387	A	MGFMNS	101	1729	82458	5544553	0.0584	0.019246154
387	A	NEATN	33	1729	69241	5544553	0.0191	0.019246154
914	A	MGFMNS	30	1751	82458	5544553	0.0171	0.019246154
914	A	AETWAQ	35	1751	139096	5544553	0.02	0.019246154
914	A	DTUKDTUJ	20	1751	99431	5544553	0.0114	0.019246154
914	A	STJN	15	1751	151647	5544553	0.0086	0.019246154
914	A	AWEGG	15	1751	7527	5544553	0.0086	0.019246154

My problem is with the final expression. I have displayed in the table the value I would like to see (which is an average of all the values in the 5th column), but the expression doesn't work as it currently is.

Hope this is explained clearly - help would be much appreciated!

[kaushiknsolanki]

Kindly Share your application.

Regards,

Kaushik Solanki

[sunny_talwar · Accepted solution]

May be try this

Avg(TOTAL Aggr(Sum({<GEN={'ALL'}>}NUM)/Sum(TOTAL <ID> {<GEN={'ALL'}>} NUM), ID, Type, Set))

[jessica_webb]

Thank you Sunny!

Another quick,simple solution

Much appreciated,

Jess