Allow changes only in part of the rows in an input field

[sonkumamon]

Hi everyone.

I need to allow changes in only parts of the rows in an input field.

For example, Actual is the input field, and I want to allow the user to change only the cells in yellow

(Since dimension 4 and 7 are the sum of their previous 2 rows):

Dimension	Actual	Target
1	36	40
2	18	15
3	769,540	1,000,000
4	54	45
5	5	4
6	2	3
7	7	7

Is there any  way to do so?

Thanks in advance.

Uri

[Anil_Babu_Samineni]

May be this?

If(Match(Dimension, 1,2,5,6), [Target Expression], [Target Expression])

OR

Sum(Aggr(If(Match(Dimension, 1,2,5,6), [Target Expression], [Target Expression]), Dimension))