Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
Please help to create a graph to show in dimension "Group" where Group = "E" "Amount" (expression sum) allocated among other groups which group the code belongs.
I have the following data model:
LOAD * INLINE [
EmplID, Group, Amount, Code
1, A, 100, 123
2, B, 200, 234
3, C, 300, 345
4, A, 400, 456
5, B, 500, 123
6, E, 600, 234
6, E, 700, 123
];
LOAD * INLINE [
Manager, Code, Group
Manager 1, 123, A
Manager 2, 234, B
Manager 3, 456, A
Manager 4, 345, C
];
Expected output?
Graph can be a straight table with dimension "Group" and expression "=sum(Amount)". But I need to allocate amount for group "E" among other groups. How can I do??
Like this??
Dimension : Group
Expression : Sum({<Group = {'E'}>} Amount)
How should the values be distributed?
123 of E is in A and B is to be distributed 50 50 or proportionally
234 of E is only available in B
in your INLINE model are synthetic key
Greeting Gerold
No, please carefully read question
The distribution should be 100% for A and 100% for B, but when script read group "E" it should refer to second table and take value from Code -> Group.
To avoid synthetic key, you can rename field "Group" to "Group_2".