Dinamic Profit and loss

[joseduque]

Hi Everyone,

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.

Regards,

Jose