New Expression - % average of % expression values based on Dimension

[janturon]

Dimensions	Expressions
Group	Place	City	%OP	Avg%Op_Group
J I NR	014	Horná Kráľová	27,00%	27,47%
J I NR	015	Tlmače	28,80%	27,47%
J I NR	019	Jarok	30,18%	27,47%
J I NR	020	Mojmírovce	24,21%	27,47%
J I NR	022	Hronské Kľačany	26,56%	27,47%
J I NR	025	Čeľadice	30,28%	27,47%
J I NR	027	Hájske	25,77%	27,47%
J I NR	032	Jedľové Kostoľany	28,23%	27,47%
J I NR	034	Žitavany	29,13%	27,47%
J I NR	129	Dolné Štitáre	25,05%	27,47%
J I NR	137	Lovce	26,98%	27,47%
J I NR	Total	-	27,12%
J II NR	012	Báb	18,39%	24,93%
J II NR	013	Báb	28,45%	24,93%
J II NR	018	Lužianky	25,76%	24,93%
J II NR	125	Podhorany Bádice	27,10%	24,93%

Hello, I have table see above....

%OP is this expression:

= (Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'604'}>}MDD)
-
Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}>}MDD))
/
Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}>}MDD)

I need help with create expression  Avg%Op_Group.

It means average %OP for Dimension "Group".

[sunny_talwar · Accepted solution]

May be try this

=Avg(TOTAL <Group> Aggr(
(Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'604'}>}MDD)
-
Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}>}MDD))
/
Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}>}MDD)

, Group, Place, City))

[janturon]

thank you. 🙂