Expression for category wise aggregation

Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I will explain the problem with an example.

A table has 3 columns(ID, Field and Value) and the fourth column shows the desired result from expression while representing this data:

ID	Field	Value	Value Expected from Expression
1	A	1	1/(1+2+3)
1	B	100	100/(100+200+300)
1	C	10000	10000/(10000+20000+30000)
2	A	2	2/(1+2+3)
2	B	200	200/(100+200+300)
2	C	20000	20000/(10000+20000+30000)
3	A	3	3/(1+2+3)
3	B	300	300/(100+200+300)
3	C	30000	30000/(10000+20000+30000)

In words, it can be put as Value / (Sum of Values from rows where field is same as field in current row).

Can somebody help me with the expression?

Thanks in advance:).

Re: Expression for category wise aggregation

MK_QSL — Mon, 27 Jun 2016 08:58:41 GMT

Use below expression

SUM(Value)/SUM(TOTAL <Field> Value)

Mon, 27 Jun 2016 09:15:05 GMT

Hi Manish,

It is exactly what I wanted.

Thank you so much for your help.