Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
Hi,
Can you not do this without AGGR, say;
Sum(Value)/sum(TOTAL <Date, User> Value)
Cheers,
Chris.
Hi,
Can you not do this without AGGR, say;
Sum(Value)/sum(TOTAL <Date, User> Value)
Cheers,
Chris.
Yess Thats great thank you Chris😊
regards