I have and special request, have some tables with different percentaje of participation:
Distribution A
Center
%
Personal
IND
25
PYME
10
CONS
30
MAS
35
Distribution B
Center
%
Sales
IND
10
PYME
30
CONS
20
MAS
40
Distribution C
Center
%
Comision
IND
40
PYME
30
CONS
15
MAS
15
And on the other I have my Profit and Lost table, what I want to do is to change the values of the accounts dinamically to any of the Distribution A,B or C (basically on demand in the design)
Distribution
Total
IND
PYME
CONS
MAS
Sales
8100
1875
1410
2080
2735
A
Credit
5000
1250
500
1500
1750
B
Dollar
2000
200
600
400
800
C
Paycheck
1000
400
300
150
150
A
Cards
100
25
10
30
35
Note.- Distribution is variable and on demand, the client need to change for account the distribution in the desing
Example I want to change the account Cards to other distribution change A from C and then the table has to recalculated.
This example is in Account level so the father Sales account has to sum the new values.
Distribution
Total
IND
PYME
CONS
MAS
Sales
8100
1890
1430
2065
2715
A
Credit
5000
1250
500
1500
1750
B
Dollar
2000
200
600
400
800
C
Paycheck
1000
400
300
150
150
C
Cards
100
40
30
15
15
Is it posible to make this kind of dinamyc selection in a table or should be variable objects? The problem I see is the sum of the father count in the table. Anyway Hope any suggestion.
