aggr function

[mert1917]

Hi everyone,

I hope you are fine:)

Can you help me with this formula(Type%-column)

How can I find the percentage distribution of Type Values according to the Aggr column?

regards..

Date	User	Type	Value	Aggr	Aggr-Formula	Type%	Type%-Formula?
01/05/2020	U1	T1	200	900	Aggr( sum(Value),Date,User)	22%	Aggr( sum(Value),Date,User,Type)/Aggr( sum(Value),Date,User)
01/05/2020	U1	T2	300	900		33%
01/05/2020	U1	T3	400	900		44%
01/05/2020	U2	T1	200	700		29%
01/05/2020	U2	T2	200	700		29%
01/05/2020	U2	T3	300	700		43%
02/05/2020	U1	T1	500	1000		50%
02/05/2020	U1	T2	200	1000		20%
02/05/2020	U1	T3	300	1000		30%
02/05/2020	U2	T1	150	650		23%
02/05/2020	U2	T2	200	650		31%
02/05/2020	U2	T3	300	650		46%

[chrismarlow · Accepted solution]

Hi,

Can you not do this without AGGR, say;

Sum(Value)/sum(TOTAL <Date, User> Value)

Cheers,

Chris.

[mert1917]

Yess Thats great thank you Chris😊

regards